"Alexander Steffens" <[EMAIL PROTECTED]> 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! ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
