Diff. between FIRST_ROWS and INDEX hint

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.

Dana

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

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