But this becomes non-maintanable if you have, say, 5 columns in a table that
you can do lookups on that have a low cardinality.
"Daniel" <twinsxu_at_yahoo.com> wrote in message
news:e0e46f5b.0112051219.4b3823c1_at_posting.google.com...
> 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 - 15:06:24 CST
