Jim Morris wrote, On 26/04/12 15:36:
It is possible using an alias would force better behavior:
selsect theDate
from (select transfer_date as theDate from transfer_history
where regn_no='039540' and transfer_date<= '2012-05-01') order by
theDate
Once again, it makes no difference - the planner still picks the same
plan using scans.
--
Peter Hardman
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users