yes -- unless one is UNIQUE, of course
"Daniel Roy" <danielroy10junk_at_hotmail.com> wrote in message
news:3722db.0311041726.52c94d2c_at_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 Wed Nov 05 2003 - 06:27:07 CST
