Da Martian wrote:
I cannot tell if sqlite uses my indeces or not. Is there a way
to tell what indexes are used in a query ?
Use the explain query plan command. Simply add these keywords before
your query.
EXPLAIN QUERY PLAN SELECT ....
Instead on the query results you will get a table listing the tables and
indexes that will be used to implement your query.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------