Request a Demo
Home   >   mailing lists

How to avoid multiple table scan with "NOT IN" - Mailing list pgsql-general

From Nick
Subject How to avoid multiple table scan with "NOT IN"
Date
Msg-id ba6aa9cf-a72f-42a8-932e-f511c9ab6872@u9g2000pre.googlegroups.com
Whole thread Raw
Responses Re: How to avoid multiple table scan with "NOT IN"
List pgsql-general
Tree view 
Is there any way this query could be written that doesnt scan the
subquery table twice?

SELECT * FROM my_table
WHERE (one,two) NOT IN (SELECT sub_one, sub_two FROM my_sub_table)
AND (two,one) NOT IN (SELECT sub_one, sub_two FROM my_sub_table)

pgsql-general by date:

Previous
From: Jerry LeVan
Date:
Subject: Re: Messed up dblink...
Next
From: Tom Lane
Date:
Subject: Re: How to avoid multiple table scan with "NOT IN"