On 06/25/07 09:58, Tom Lane wrote: [snip]
The fly in the ointment is that if the column value is so high cardinality as all that, it's questionable whether you want an index search at all rather than just seqscanning; and it's definite that the index access cost will be only a fraction of the heap access cost. So the prospects for actual net performance gain are a lot less than the index-size argument makes them look.
Well they definitely are for data warehouses, in which many high-cardinality columns each have an index.
Because of their small disk size, ANDing them is fast and winnows down the result set. That's the theory, of course.
-- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good!
