Re: Slow Query

In the 'not exists' cluster, you do not have to search table "Vacancy as v" again.

I think it would be faster to use the outer Vacancy table as below.

In your case, that do the same work.

NOT EXISTS (

        SELECT 1

        FROM "CategoryOption_TableRow" "ct126" 

        WHERE "Vacancy"."Template"

          AND "ct126"."CategoryOptionID" IN (34024,35254,35255,35256)

          AND "ct126"."Category_TableID" = 126

          AND "ct126"."RowID" = "Vacancy"."ID"

          )

---

If you reply to this email, your message will be added to the discussion below:

http://postgresql.nabble.com/Slow-Query-tp5861835p5862008.html

To unsubscribe from Slow Query, click here.
NAML