db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Vatter <thomas.vat...@network-inventory.de>
Subject order by
Date Tue, 28 Feb 2006 09:12:56 GMT
I have checked the values in the database, they have no leading spaces.
The names are only a simple example for describing the problem, the
data structure is more complex and the query has joins and conditions.
This query was working with other dbms but it had no composite index,
I have added the composite index for making it faster (and it does).
I have made a test and dropped the composite index, and now the
sorting is ok, regenerated the index and sorting is as described
in my first problem report.


View raw message