At 16:46 17/04/2007, you wrote:
This is news to me. Why can't SQlite use more than one index?
Possibly because it's 'SQ *Lite*'?
The query optimiser in SQLite is a lot less powerful than in some
other SQL databases - but then it's a fraction of the size as well...
Instead of having two indices on columns A and B, you need to
consider having another index on both columns at once.
Paul VPOP3 - Internet Email Server/Gateway
[EMAIL PROTECTED] http://www.pscs.co.uk/
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
