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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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