index usage

[Franklin Schmidt]

Given an index on (s,i) and a query like:

        select * from t where s=? order by i

the optimizer should use the index for both the selection and the
order.  The attached example shows that the index is not used for the
order.

--

You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-datab...@googlegroups.com.
To unsubscribe from this group, send email to 
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

HB4.java
Description: Binary data