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: Alan <alan_at_erols.com>
Date: Tue, 4 Nov 2003 09:57:18 -0500
Message-ID: <bo8eoq$19hufs$1@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 - 08:57:18 CST












Original text of this message













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