On Mon, 1 Jun 2009, Shaul Dar wrote:
Our typical query select 300 random rows (could be located in different
blocks) from the table based on another
column+index, and then filters them down to ~50 based on this the bit field.
So it seems that you're already using an index to fetch 300 rows
Shaul Dar wrote:
Hi,
I have at column that is a bit array of 16, each bit specifying if a certain
property, out of 16, is present or not. Our typical query select 300
random rows (could be located in different blocks) from the table based on
another column+index, and then filters them down to
Shaul Dar shaul...@gmail.com writes:
I have at column that is a bit array of 16, each bit specifying if a certain
property, out of 16, is present or not. Our typical query select 300
random rows (could be located in different blocks) from the table based on
another column+index, and then