Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Which index is used when multiple are valid

Re: Which index is used when multiple are valid

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 4 Nov 2003 17:26:21 -0800
Message-ID: <3722db.0311041726.52c94d2c@posting.google.com>


Everything is under RBO (because Siebel enforces this), and therefore these 2 indices are created equal.

Daniel

> 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 - 19:26:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US