Siraj G writes:
> Please find below the query in the format and its execution plan:
[ blink... ] I'm not sure what you are using there, but it is
*not* Postgres. There are assorted entries in the execution
plan that community Postgres has never heard of, such as
> -> Remove duplicate (P0, IS_S
Hello Adrian!
Please find below the query in the format and its execution plan:
SELECT
em_exists_idFROM
IS_SEC_FILTWHERE (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
On 9/19/24 21:07, Siraj G wrote:
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):
Add the output of the EXPLAIN ANALYZE for the qu
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_GU
