ramprakash ha scritto:
> 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.
I try .... but it is only an idea
If your one or 2 columns are a key you could try to think to use an IOT
> Need some alternate solution.
>
> Regards
> Ram
>
Received on Mon Mar 20 2006 - 05:47:23 CST
