Black, Michael (IS) wrote, On 26/04/12 16:38:
And does this also work? Sounds like the planner isn't seeing all the columns
in the view unless in the select.
SELECT transfer_date,regn_no FROM transfer_history_new
WHERE regn_no = '039540' and transfer_date<= '2012-05-01'
order by transfer_date asc
No, that uses scans as well.
I'm tempted to suggest this might be a bug since the pattern seems
illogical.
Pete
--
Peter Hardman
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users