Indexing Strategy for a big table

[jimaricat]

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

[Shestakov]

-----------------------------------------------
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)