Re: Bitmap Index, when use it?
Date: Fri, 01 Feb 2008 12:10:00 GMT
"Cassiano" <cassianoroloff_at_gmail.com> wrote in message news:bf7a382d-e346-4e19-94fe-591f74ffb06c_at_l1g2000hsa.googlegroups.com...
> I've a table wich 6 milions of rows, and this table have one column
> "TYPE" char(2).
> This column is used to descript the type of the row.
> This column have 35 distict values and is frequently used in "where"
> I think this is a good column to create an Bitmap index? It's true? or
> 35 distict values is so much to bitmap indexes?
> Thanks for help.
This Blog entry of mine might interest you:
It discusses how bitmap indexes can actually be very beneficial with many tens of thousands of distinct column values. Suggestions that Bitmap Indexes should only be used for "handfuls" of distinct columns is one of those dear little Oracle myths we all love and know so well ...
http://richardfoote.wordpress.com/ Received on Fri Feb 01 2008 - 06:10:00 CST