[thelist] DB "Limit" Command Question
Matt Warden
mwarden at gmail.com
Thu Apr 16 14:26:35 CDT 2009
On Thu, Apr 16, 2009 at 2:18 PM, Luther, Ron <Ron.Luther at hp.com> wrote:
> What if I run a 'select field1, field2, field3 from tableA' that contains a 'limit output to 20 records" clause?
>
> Does it run through the whole table and then return 20 records? Or does it stop executing at 20 records and return?
>
It will stop at 20 records if you have no operations that require the
full data set (order by, grouping, etc)
--
Matt Warden
Cincinnati, OH, USA
http://mattwarden.com
This email proudly and graciously contributes to entropy.
More information about the thelist
mailing list