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: Tunning Select and Where statements

Re: Tunning Select and Where statements

From: John Chiu <johnc_at_relsol.com>
Date: Tue, 28 Sep 1999 11:31:54 -0400
Message-ID: <7sqmmu$104$1@newsmaster.pathcom.com> 





When selecting by age(where age is an index), the query will go through the
index and get the rowids, then go to the table and get the names. If you
have the name and age included in the index, the query will just obtain the
names in the index in the first pass without going to read the table.



HTH


John Chiu


Received on Tue Sep 28 1999 - 10:31:54 CDT












Original text of this message













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