Postgres Pro
Downloads
Home   >   mailing lists

Need assistance in converting subqueries to joins - Mailing list pgsql-general

From Siraj G
Subject Need assistance in converting subqueries to joins
Date
Msg-id CAC5iy60YRzqRSyC=hAZneURdCTAsRPH313jJzK9gF6-nkvwGPA@mail.gmail.com
Whole thread Raw
Responses Re: Need assistance in converting subqueries to joins
List pgsql-general
Tree view
Hello Tech gents!

I am sorry if I am asking the wrong question to this group, but wanted assistance in converting a query replacing subqueries with joins. 

Please find the query below (whose cost is very high):

select em_exists_id from IS_SEC_FILT WHERE (IS_SEC_FILT_GUID) NOT IN (SELECT IS_OBJ_GUID FROM TMP_IS_SEC_FILT T0, IS_PROJ P0 WHERE T0.IS_PROJ_GUID = P0.IS_PROJ_GUID AND P0.IS_PROJ_ID = IS_SEC_FILT.IS_PROJ_ID) AND (IS_PROJ_ID) IN (SELECT IS_PROJ_ID FROM IS_PROJ P0, TMP_IS_SEC_FILT T0, EM_MD R0 WHERE T0.IS_REPOSITORY_GUID = R0.REP_GUID AND T0.IS_PROJ_GUID = P0.IS_PROJ_GUID AND P0.IS_REPOSITORY_ID = R0.REP_ID);

Regards
Siraj

pgsql-general by date:

Previous
From: Durgamahesh Manne
Date:
Subject: Synchronize the dump with a logical slot with --snapshot
Next
From: Adrian Klaver
Date:
Subject: Re: Need assistance in converting subqueries to joins