Subject: Re: DBMS and lisp, etc.
From: rpw3@rpw3.org (Rob Warnock)
Date: Sun, 23 May 2004 04:54:52 -0500
Newsgroups: comp.lang.lisp
Message-ID: <-aKdnQDe1sFx6S3dRVn-hg@speakeasy.net>
David Steuber  <david@david-steuber.com> wrote:
+---------------
| rpw3@rpw3.org (Rob Warnock) writes:
| > [LIMIT 10] would get you just the 10 latest values, no matter
| > how many rows in the table matched.
| 
| Oracle also supports LIMIT.  The DB itself may internaly still go
| through the entire table to do the sort even though it only returns
| up to LIMIT results.
+---------------

Possibly, though after a number of runs perhaps the query optimizer
might be able to do something better. At least you'd be *telling* it
in a declarative way what you really want, whether or not a particular
query optimizer contains the mythical "sufficiently-smart compiler"
to make use of the information...


-Rob

-----
Rob Warnock			<rpw3@rpw3.org>
627 26th Avenue			<URL:http://rpw3.org/>
San Mateo, CA 94403		(650)572-2607