indexing issue, need alternate solution to improve the query performance

Hi,

i am facing a scenario like this,

i am having a table having around 1 million rows, and 15 columns. This is the logging table, mostly insertion only happens. the query we use from front end uses almost any one or two of the 10 columns in the where condition.
since it a log table and insertions are heavy, i cant create index for all the columns.
Need some alternate solution.

Regards
Ram Received on Mon Mar 20 2006 - 05:14:42 CST