Hello Hugo,
If you preceed a SELECT with the string
EXPLAIN QUERY PLAN
sqlite will make it clear which, if any, indices it would use when
running the select.
Sqlite, unlike some of the "non-light" databases, uses a maxium of one
index per table per select, I believe.
You may want to look at the ANALYZE command.
You really do want a CROSS JOIN in the first case, is that right?
I'm not sure if this is info you're looking for.
Regards, and Happy New Year to all,
Donald G.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
