Hi, all!  When I use setMaxRows() in JDBC, I know it limits the number of rows delivered through JDBC.  I just wanted to confirm that when I use this, Derby doesn't still scan through all rows and then deliver maxRows number of rows to JDBC - that it only actually goes through the first N rows (assuming my query uses an index).

e.g.

SELECT id FROM mytable

with setMaxRows(5)

Derby will only go through the first 5 rows in the index...  right?

Thanks!

David

--
David W. Van Couvering

http://www.linkedin.com/in/davidvc
http://davidvancouvering.blogspot.com
http://twitter.com/dcouvering