Hi,
On 2 October 2012 12:33, Toby Corkindale
<toby(dot)corkindale(at)strategicdata(dot)com(dot)au> wrote:
> I have a query that joins two views, and takes 28 seconds to run.
> However if I create temporary tables that contain the contents of each view,
> and then join them, the total time is 1.3 seconds.
try "offset 0" (or you can tweak statistics collector to get better estimates):
select ... from (select * from view offset 0) as v ....
http://blog.endpoint.com/2009/04/offset-0-ftw.html
--
Ondrej Ivanic
(ondrej(dot)ivanic(at)gmail(dot)com)