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 -> USING INDEXES

USING INDEXES

From: Mark Ragan <mark.ragan_at_dial.pipex.com>
Date: Mon, 15 Nov 1999 13:54:17 -0000
Message-ID: <80p38e$94p$1@lure.pipex.net> 





I have a table which contains many fields, one of which is "OrderNo".



This "OrderNo" WILL have duplicate entries.



I have created an index on this field.



When doing a "Select * from Filename ORDER BY OrderNo" Oracle sorts each
record before outputting.



How can I force Oracle to use the index?



Why doesn't it use this index by default?.



TIA




Received on Mon Nov 15 1999 - 07:54:17 CST












Original text of this message













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