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&#39;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).<div>

<br></div><div>e.g.</div><div><br></div><div>SELECT id FROM mytable</div><div><br></div><div>with setMaxRows(5)</div><div><br></div><div>Derby will only go through the first 5 rows in the index...  right?</div><div><br></div>

<div>Thanks!</div><div><br></div><div>David<br clear="all"><br>-- <br>David W. Van Couvering<br><br><a href="http://www.linkedin.com/in/davidvc">http://www.linkedin.com/in/davidvc</a><br><a href="http://davidvancouvering.blogspot.com">http://davidvancouvering.blogspot.com</a><br>

<a href="http://twitter.com/dcouvering">http://twitter.com/dcouvering</a><br>
</div>