Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: low cardinality columns and indexing.
I will suggest that you store these 50 millions rows into a
partitioned table by using each cardinality as the key for each
partition.
"ayrobins" <anthony_at_lumos.com> wrote in message news:<gurP7.80$6e6.12047_at_dca1-nnrp2.news.digex.net>...
> I am using the standard edition of oracle. I realize that bitmap indexes
> aren't supported.
>
> I have a table that can contain around 50 million records and can be looked
> up by column
> X. X has a cardinality of 20. i.e. it can contain 20 distinct values. A
> lookup by 'X' can
> will be done often.
>
> Does it make sense to not use an index at all. Or is a Btree index better
> then nothing.
Received on Wed Dec 05 2001 - 14:19:37 CST