"Alexander Steffens" <mail(at)a-st(dot)de> writes:
> Hello, I have found an Query (with data)
> that need to execute on MS-SQL 2005 < 9sec,
> on Postgresql I will stop it now after more than 30 mins:
> insert into t1
> select distinct (t1.a + t2.a)*2
> from t1,t2
> where not exists (
> select * from t1 tt where tt.a = (t1.a + t2.a)*2
> )
What plan does MS-SQL use to complete this? I wonder whether it's producing
the same answer Postgres is.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support!