Black, Michael (IS) wrote, On 26/04/12 17:05:
What version are you using? Can you extract an example of all your
tables/indexes/data to demonstrate?
I'm on 3.7.11 (Arch-Linux).
You can grab a database at
http://www.somborneshetlands.co.uk/things/sss-test-nomem.zip
You will need to use a regn_no of 023674 with that as its a cut down
data set for testing (the live one is 35MB). The date can remain the same.
One more idea. Explicitly ask for the indexes...and a compound index
might be nice to have around.
I dont' think you can ask for more than one index without doing
subselects, can you?
AFAIK you can't create indexes on a view, or can you?
Pete
--
Peter Hardman
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users