Re: Slow Query

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(at)gmail(dot)com>:

> 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(at)repica(dot)co(dot)jp> wrote:
>
>> Is the "Vacancy"."ID" a primary key?
>> Or is unique in Vacancy table?
>>
>>
>
>
> --
> Regards
>
> Robert Campbell
> +61412062971
> robcampbell73(at)gmail(dot)com
>