Stergios Zissakis wrote:
My question is: shouldn't sqlite's engine figure out what I am trying
to do and sort the tables on the fly in an effort to optimize the query?
When using no indexes, a .explain reveals 3 nested loops which take a
long time to return results.
Any help/ideas will be much appreciated.
You should read the optimizer docs at
http://www.sqlite.org/optoverview.html for an explanation of why this
happens.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
