[thelist] DB "Limit" Command Question

[Matt Warden]

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.