Re: First_Rows hint

From: "Connor McDonald" <mcdonald.connor@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Wed, 26 Apr 2006 20:34:07 +0800

You could say the "buffer" is "one", in the sense that first_rows
historically was an optimization facility to get the very first row back as
quickly as possible...but you could probably just as easily say "first rows
= nested loops if possible", or "first rows = rule with a cost number to
make you feel better about things"

:-)

--
Connor McDonald
===========================
email: connor_mcdonald@xxxxxxxxx
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

References:

First_Rows hint
From: Fred Smith

Re: First_Rows hint

Other related posts: