Black, Michael (IS) wrote, On 26/04/12 21:39:
My fault...I thought I had extracted it under another name...turns out I was
using a different db...duh...
Well we're none of us perfect. Only the female of the species can do more than
two things at once...
Yes, that query is fine.
But add an 'order by transfer_date' clause and the planner no longer uses
indexes but uses scans instead.
Then if you do a select * ... it goes back to using indexes.
With 100K+ records in the full database the difference in execution times is not
insignificant.
Pete
--
Peter Hardman
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
