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

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 20 Mar 2006 10:24:11 -0500
Message-ID: <Rb-dnWUsZNmCVIPZnZ2dnUVZ_v-dnZ2d@comcast.com>

"ramprakash" <ramprakash.a_at_gmail.com> wrote in message news:1142866891.735167.303800_at_t31g2000cwb.googlegroups.com...
: Hi,
:
: Its oracle 9i release 2, running on windows box.
: if i need to create index,
: i have to index all the columns because, where condition in the select
: query contains almost all the columns.
:
: Regards
: Ram
:

your original question indicated that you have many different queries, each of which used one or two different columns of the table

this seems to indicate that the variety of queries is limited, but each query includes most of the columns

it would be helpful if you could post the table description and the types of queries your are tuning for

also -- posting to a single c.d.o. newsgroup is sufficient (this is probably the appropriate one)

++ mcs Received on Mon Mar 20 2006 - 09:24:11 CST