Re: Slow Query

[robbyc <robcampbell73@xxxxxxxxx>]

Hi,

Doing this returns 0 records

On Thu, Aug 13, 2015 at 7:22 PM, 林士博 [via PostgreSQL] <[hidden email]> wrote:

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

--

Regards

Robert Campbell
+61412062971
[hidden email]

---

View this message in context: Re: Slow Query
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.