[PERFORM] Terrible plan for join to nested union

I have a query which joins to a nested union and I'm getting a plan which never returns. Here is the query simplified as much as possible: select 'anything' as result from "Attribute" as A1 inner join (

Re: [PERFORM] Terrible plan for join to nested union

Nate Allan writes: > I have a query which joins to a nested union and I'm getting a plan which > never returns. Here is the query simplified as much as possible: > select 'anything' as result >from "Attribute" as A1 > inner join >

Re: [PERFORM] Terrible plan for join to nested union

Thanks for your reply Tom. >> I have a query which joins to a nested union and I'm getting a plan which >> never returns. Here is the query simplified as much as possible: >> select 'anything' as result >>from "Attribute" as A1 >> inner join >>

Re: [PERFORM] Terrible plan for join to nested union

2012/7/8 Nate Allan : > Thanks for your reply Tom. > >>> I have a query which joins to a nested union and I'm getting a plan which >>> never returns. Here is the query simplified as much as possible: >>> select 'anything' as result >>>from "Attribute" as A1 >>>