What indexes are on the underlying tables?
> -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Peter > Sent: Thursday, April 26, 2012 10:55 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Re Query planner creating a slow plan > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users