Bitmap Index, when use it?
From: Cassiano <cassianoroloff_at_gmail.com>
Date: Mon, 28 Jan 2008 05:50:31 -0800 (PST)
Message-ID: <bf7a382d-e346-4e19-94fe-591f74ffb06c@l1g2000hsa.googlegroups.com>
Date: Mon, 28 Jan 2008 05:50:31 -0800 (PST)
Message-ID: <bf7a382d-e346-4e19-94fe-591f74ffb06c@l1g2000hsa.googlegroups.com>
Hello,
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" clause.
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.
Cassiano Roloff
DBA Oracle - Porto Alegre/RS/Brazil
Received on Mon Jan 28 2008 - 07:50:31 CST