Re: [sqlite] Sorting and Descending Index

2008-03-19 Thread Dennis Cote
Martin Engelschalk wrote: > > 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

Re: [sqlite] Sorting and Descending Index

2008-03-19 Thread drh
Martin Engelschalk <[EMAIL PROTECTED]> wrote: > 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 "c

[sqlite] Sorting and Descending Index

2008-03-19 Thread Martin Engelschalk
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: