On Jul 1, 2009, at 4:15 AM, Scara Maccai wrote:
I query is using Index scan instead of Bitmap Index Scan because it
"thinks" that the number of rows returned will be low (12). In
fact, the number of rows returned is 120.
This happens because there are some WHERE conditions that check
cross
Hi,
I query is using Index scan instead of Bitmap Index Scan because it "thinks"
that the number of rows returned will be low (12). In fact, the number of rows
returned is 120.
This happens because there are some WHERE conditions that check cross-tables
values (something like taba.col1 < tabb
