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

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 20 Mar 2006 15:30:15 +0100
Message-ID: <dvme9n$sfu$1@nntp.fujitsu-siemens.com>

ramprakash schrieb:
> 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.

Then why not index only those two columns?

Besides, what is it with those indians that they never get the hang of questions? It's impolite to just go there and say "I need" and expect that someone jumps.

Volker Received on Mon Mar 20 2006 - 08:30:15 CST