Re: howto force use of indices on one table

Hi Sven,

                YOU CAN try using the appropriate hint in the query to use the index. You should know the name of the indices. Then after the SELECT keyword use hint /* AN_EQUAL(a.index1, b.index2) */

Refer to Oracle server tuning manual for more details and syntax

sanjay.

"Sven G." <gis_at_informatik.tu-chemnitz.de> wrote:
>Moin,>
>I got a table with 10 float columns (a0 .. a9) and 600000 rows. I
>created indices for each column. But when I do a select (exact or range
>match) on 2 or more columns Oracle uses only one index.
>
>At first all values per column were distinct. Than I tried only 4
>diffrent values per column. So querying a concrete value in one column
>selects 1/4 of all. I expect Oracle using the index of the next column
>to get (1/4)/4 of all and so on, instead it does a full scan of 1/4.
>
>My settings:
>optimizer goal : first_rows
>analyzed the table and each index
>
>Can anyone tell me what I did wrong?
>
>thx
> Sven
>
Received on Sat May 29 1999 - 15:44:13 CDT