Re: Slow Query

Hi,

Doing this returns 0 records

On Thu, Aug 13, 2015 at 7:22 PM, 林士博 [via PostgreSQL] <
ml-node+s1045698n5862008h81(at)n5(dot)nabble(dot)com> 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
> <http://postgresql.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5861835&code=cm9iY2FtcGJlbGw3M0BnbWFpbC5jb218NTg2MTgzNXwxOTc1MDc2ODM4>
> .
> NAML
> <http://postgresql.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>

--
Regards

Robert Campbell
+61412062971
robcampbell73(at)gmail(dot)com

--
View this message in context: http://postgresql.nabble.com/Slow-Query-tp5861835p5862122.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.