On Dec 17, 2009, at 11:20 AM, Robert Citek wrote: > Hello all, > > How can I speed up the sorting of a union all query?
If you can use UNION instead of UNION ALL and both subqueries have appropriate indices, then the ORDER BY will probably make use of the indices to extract the elements in sorted order to begin with and no sorting will occur. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
