db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ivo Petkov" <ivo.pet...@gmail.com>
Subject Limiting SQL Query results
Date Tue, 19 Jun 2007 07:49:02 GMT
Hi all,

I have the following question:

As Derby does not support the SQL Limit
) and

if I use java.sql.Statement.setMaxRows(X), does Derby stops scanning the
tables when X rows are found, or it the statement just programatically
limits the returned rows to X.
We have performance issues for a complex select query and we want to limit
the scanning of the database for example - only to the first 10 found rows.

With other words - Does Derby have such an optimization to stop scanning the
database when the first X results are found?


View raw message