As far as I know, Derby doesn't optimize based on maxRows. This is only used to limit rows returned to clients, as you mentioned below.
Satheesh Mike Matrigali wrote: >I'll start by saying that I am not an optimizer expert. I don't think >the optimizer does anything special with limits - but I could be wrong, >maybe someone else with more knowledge in that area can let us know. > > > >
