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

Home -> Community -> Mailing Lists -> Oracle-L -> Diff. between FIRST_ROWS and INDEX hint - is there any?

Diff. between FIRST_ROWS and INDEX hint - is there any?

From: dana mn <danamn2000_at_yahoo.com>
Date: Tue, 20 Feb 2001 17:20:58 -0800
Message-ID: <F001.002B9284.20010220164046@fatcity.com>

Is there any difference between the FIRST_ROWS hint
(which is said to "generally force the use of indexes" - Niemiec)
and the use of the INDEX hint (without specifying a particular index)?

Is something else going on behind the scenes with FIRST_ROWS or is this gratuitous bloat that shouldn't be in the optimizer? (or a placeholder for future innovation)?

Thanks very much.


Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dana mn
  INET: danamn2000_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Feb 20 2001 - 19:20:58 CST

Original text of this message

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