michael cuthbertson wrote:
To summarize, in this query with indexes on most columns, SQLite will only
use time1 index and is slower doing so.
Could someone please explain to me why this happens?
Michael,
You may want to check out the ANALYZE command. It creates an internal
table with statistics about your indexes which sqlite uses to select the
optimal index when it prepares a query.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------