I couldn't find an open JIRA entry for enhancing Derby to make
> using of opposite-ordered indexes when doing ORDER BY.
I think that DERBY-884 and DERBY-642 are related: http://issues.apache.org/jira/browse/DERBY-642 http://issues.apache.org/jira/browse/DERBY-884 However, they don't specifically mention ORDER BY. thanks, bryan