Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: indexing issue, need alternate solution to improve the query performance
ramprakash wrote:
> 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.
And we need more information. Please post DDL, versions and some typical queries.
Cheers
robert Received on Mon Mar 20 2006 - 08:16:43 CST