Skip site navigation (1) Skip section navigation (2)

optimize sql

From: pgsql-sql(at)fc(dot)emc(dot)com(dot)ph (pgsql-sql)
To: pgsql-sql(at)postgresql(dot)org
Subject: optimize sql
Date: 2000-07-26 14:11:15
Message-ID: fc.000f567200599eab000f567200599eab.599ef1@fc.emc.com.ph (view raw or flat)
Thread:
Lists: pgsql-sql
HI!

The SQL below is too slow.

SELECT name FROM office, office_application 
WHERE code = office_code 
AND name NOT IN
(SELECT DISTINCT name FROM office, office_application
WHERE active = 't' AND code = office_code);

Can anyone tell me how to optimize it?
Thanks.



Responses

pgsql-sql by date

Next:From: Ross J. ReedstromDate: 2000-07-26 15:51:07
Subject: Re: optimize sql
Previous:From: Volker PaulDate: 2000-07-26 12:01:18
Subject: Re: Change attribute of a column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group