Subject: Re: DBMS and lisp, etc.
From: (Rob Warnock)
Date: Sun, 23 May 2004 04:54:52 -0500
Newsgroups: comp.lang.lisp
Message-ID: <>
David Steuber  <> wrote:
| (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 Warnock			<>
627 26th Avenue			<URL:>
San Mateo, CA 94403		(650)572-2607