db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik" <dag.wan...@oracle.com>
Subject Re: Performance problem with derby
Date Thu, 01 Sep 2011 04:11:20 GMT
On 8/31/2011 7:19 PM, Mike Matrigali wrote:
>
> The OFFSET feature is relatively new to derby and I am not sure if the 
> optimizer has been fully updated to understand it.  Maybe someone who
> knows more about the OFFSET feature can comment if the optimizer has 
> been updated to know that this query is only going to look at 50 rows
> rather than all of them?

It hasn't been updated to understand this yet.

Dag


Mime
View raw message