Hello All, I have to select data from a large table (several million records) in descending order and created an index for that purpose. However, sqlite seems not to use this index for selecting the data.
In the documentation of the "create index" - statement, i found the following sentence: "Each column name can be followed by one of the "ASC" or "DESC" keywords to indicate sort order, but the sort order is ignored in the current implementation. Sorting is always done in ascending order." However, the news for Version 3.3.0 of Jan 2006 says: "Version 3.3.0 adds support for .... DESC indices". Is this a contradiction? Can sqlite use an index for order by ... desc - clauses? Or am i doing sonething wrong? Thanks, Martin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users