RE: Order by question - newbie

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Tue, 28 Aug 2001 12:58:38 -0700
Message-ID: <F001.0037A5BC.20010828131822@fatcity.com>

If
your grabing all rows, and your calling all columns (some in order, some display) why wouldn't it do a fts?There is no reason to use the index.
Now if you overloaded the index,
it may opt to use the index, but to what avail?  It is is the same size of the table.
 

<FONT face=Arial color=#0000ff
size=2>In overloading, I refere to puting PersonalCode at the end of the index you created, this way all teh data will be available from the index, there will be no need to go to the table, altough the table will be the same size as the index, but the index will already be sorted. <FONT face=Arial color=#0000ff
size=2> 
<FONT face=Arial color=#0000ff
size=2>Perhaps you may want to look at IOT, if this isn't high write table.
 
 

"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence <FONT

face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS" 
size=2>Phone: (978) 322-5744 <FONT face="Comic Sans MS" 
size=2>Fax:    (707) 885-2275 

Fuelspot <FONT

face="Comic Sans MS" size=2>73 Princeton Street <FONT 
face="Comic Sans MS" size=2>North, Chelmsford 01863 <FONT 
face="Comic Sans MS" size=2>  

  

  <FONT
  face=Tahoma size=2>-----Original Message-----From: Csillag Zsolt   [mailto:starsoft_at_interware.hu] Sent: Tuesday, August 28, 2001 3:37   PMTo: Multiple recipients of list ORACLE-LSubject: Order   by question - newbie
  Hi,I have a table with 3 colums
  :  PersonalCode,  Name and  SpecialOrder.The   PersonalCode is the primary index and I have also an index  on   SpecialOrder,Name columns.However the following select:Select   PersonalCode From MyTable  Order By SpecialOrder,Namedoesn't   use the  SpecialOrder,Name index at all. If I watch it in Explain   Plan window I can see that :SELECT STATEMENT, GOAL =

  CHOOSE                 1181    16378   2456700 SORT 

  ORDER

  BY                  1181    16378   2456700  

  TABLE ACCESS
  FULL     ADMIN   <FONT
  face="Times New Roman, Times">MyTable 69      16378   2456700How   can I make the index work? Thank you in   advance
  Zsolt
  CsillagHungary Received on Tue Aug 28 2001 - 14:58:38 CDT