On Oct 1, 2012, at 22:33, Toby Corkindale <toby.corkindale@strategicdata.com.au> wrote:
> Hi,
> Is there any way to force the query planner to do a materialisation stage?
>
> 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.3seconds.
>
> Is there a way to hint to the query planner that it should be taking that approach?
>
> Thanks,
> Toby
>
>
Have you tried?
With v1 as (), v2 as () select v1 join v2
David J.