db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Does Derby optimize queries w/ ORDER BY and "LIMIT"? (w/ indexes?)
Date Tue, 05 Jul 2005 18:39:22 GMT
As far as I know, Derby doesn't optimize based on maxRows. This is only
used to limit rows returned to clients, as you mentioned below.


Mike Matrigali wrote:

>I'll start by saying that I am not an optimizer expert.  I don't think
>the optimizer does anything special with limits - but I could be wrong,
>maybe someone else with more knowledge in that area can let us know.

View raw message