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

Reply via email to