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