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

Home -> Community -> Usenet -> c.d.o.tools -> index never used

index never used

From: Jesús Marín <jesus_at_aplsoft.es>
Date: 2000/07/25
Message-ID: <397DD41D.5066444F@aplsoft.es>#1/1 






I have a table indexed by name and indexed by code. Code is a numeric
item and name a varchar2(30).


As I use "select * from table order by code", it works fine using the
appropiate index but as I order it by name, it always makes a sort as I
see in the plan.


Anybody knows why?
Received on Tue Jul 25 2000 - 00:00:00 CDT












Original text of this message













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