Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> low cardinality columns and indexing.

low cardinality columns and indexing.

From: ayrobins <anthony_at_lumos.com>
Date: Wed, 05 Dec 2001 15:58:04 GMT
Message-ID: <gurP7.80$6e6.12047@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 - 09:58:04 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US