[sqlite] Indexing problem

Thank you for spelling out that only one index can be used per query - probably a basic principle for sqlite experts, but one that had passed me by! The following tuning guide mentions that "if there is a choice of indexes, the query optimizer may make a bad choice":

[sqlite] Indexing problem

table would make a huge difference in how this query will perform, I think. -Tom > -Original Message- > From: John Proudlove [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 14, 2005 10:26 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Indexing problem > > H

[sqlite] Indexing problem

Hello, Can anyone shed light on the following problem, experienced with the SQLite command line utility (v3.0.8) on Solaris/SPARC? The query below hangs (fails to complete within 5 minutes) using the indices shown, but after removing the index on the Season column (used in the WHERE condition),