Re: Which index is used when multiple are valid

alan,

i don't know what proceeded this in the thread, so maybe this has been covered

in the example shown, in index on COL_A will be used if it is more selective (and oracle knows it is more selective

was the assumption that all index access costs evaluated equally?

again, sorry if this was already considered.

• mcs

"Alan" <alan_at_erols.com> wrote in message news:bo8eoq$19hufs$1_at_ID-114862.news.uni-berlin.de...
> In
>
> select * from my_table where col_a = 'A' and col_b = 'B';
>
> and col_b='B' is righmost. The most far to the right in the expression.
>
>
> "Daniel Roy" <danielroy10junk_at_hotmail.com> wrote in message
> news:3722db.0311031909.19730b5d_at_posting.google.com...
> > What do you mean by "rightmost"?
> >
> > Daniel
>
>
Received on Tue Nov 04 2003 - 13:31:30 CST