Re: indexing issue, need alternate solution to improve the query performance

On Mon, 20 Mar 2006 03:11:09 -0800, ramprakash wrote:

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

Create index on the columns that are most frequently used in queries. You'll find out which ones are those by querying SYS.COL_USAGE$

-- 
http://www.mgogala.com