-
hi all,.
I have a table with 4 million records.
it has four major 'WHERE' columns out of 13 columns
at a time , only one of the columns are used for fetching.
my main concern is how to index that table.
currently there is one bitmap index on one field,.and i dont want to drop that .
i'm not sure whether it will affect the performance, if i add more indexing on the same table.
please give me a tip to how to index and to use which indexing method.
thanx nd regards
Jim
-
-----------------------------------------------
only one of the columns are used for fetching
-----------------------------------------------
Ur tactict should be in using FAST SCAN ON INDEX
then u may:
have to use B+ index on " 4 major WHERE cols + 1 column that using for fetching (probaply it have to be last if list of fields)
