Re: Slow Query

[林士博 <lin@xxxxxxxxxxxx>]

OK.

If you benchmark that correctly, 

then it seems that adding some redundant search can get the query faster in some special cases.

And without further info, I can not see any reason.

2015-08-14 14:35 GMT+09:00 Robert Campbell <robcampbell73@xxxxxxxxx>:

Hi,

My mistake, didnt apply the sub query properly the first time.

It does return records but not quite as fast as original query, about 200ms slower

Vacancy ID is a primary key.

On Fri, Aug 14, 2015 at 3:10 PM, 林士博 <lin@xxxxxxxxxxxx> wrote:

Is the "Vacancy"."ID" a primary key?

Or is unique in Vacancy table?

--

Regards

Robert Campbell
+61412062971
robcampbell73@xxxxxxxxx