aaa.sql

text/plain
Filename: aaa.sql
Type: text/plain
Part: 1
Message: bitmapscan test, no success, bs is not faster
set  enable_bitmapscan to off;

explain analyze select * from sp_op_uct where sp_op_id in 
  (select sp_op_id from sp_op_produkt where bal_zak = 34123) or sp_op_id = 34123;

explain analyze select * from sp_op_uct where sp_op_id in 
  (select sp_op_id from sp_op_produkt where bal_zak = 34123 union all select 34123); 

explain analyze select * from sp_op_uct where sp_op_id in 
  (select sp_op_id from sp_op_produkt where bal_zak = 34123) 
  union all select * from sp_op_uct where sp_op_id = 34123;

set  enable_bitmapscan to on;

explain analyze select * from sp_op_uct where sp_op_id in 
  (select sp_op_id from sp_op_produkt where bal_zak = 34123) or sp_op_id = 34123;

explain analyze select * from sp_op_uct where sp_op_id in 
  (select sp_op_id from sp_op_produkt where bal_zak = 34123 union all select 34123); 

explain analyze select * from sp_op_uct where sp_op_id in 
  (select sp_op_id from sp_op_produkt where bal_zak = 34123) 
  union all select * from sp_op_uct where sp_op_id = 34123;