On Thu, Dec 17, 2009 at 1:32 PM, Igor Tandetnik <[email protected]> wrote: > Robert Citek <[email protected]> > wrote: >> How can I speed up the sorting of a union all query? > > Basically, you can't. An index can't be used for this. Consider changing your > requirements, or your design, to make such a query unnecessary.
Thanks, Igor. A quick workaround was for me to trade space for time by creating a temporary table, creating an index, and then querying the temporary table. Seems faster, but will post numbers in a bit. Regards, - Robert _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
