What indexes are on the underlying tables?
> -----Original Message----- > From: [email protected] [mailto:sqlite-users- > [email protected]] 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
