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

On 20 Mar 2006 07:04:05 -0800, "ramprakash" <ramprakash.a_at_gmail.com> wrote:

>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.
>
>for example take the emp table
> one of the query where condition is NAME in another hiredate , mgr ...
>
>Regards
>Ram

So you believe full table scans are bad. When in the previous milennium did you learn Oracle, or read the performance tuning manual? Or do you like to believe fairy tales?

--
Sybrand Bakker, Senior Oracle DBA