[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

This email proudly and graciously contributes to entropy.

More information about the thelist mailing list