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 <robcampbel...@gmail.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, 林士博 <l...@repica.co.jp> wrote: > >> Is the "Vacancy"."ID" a primary key? >> Or is unique in Vacancy table? >> >> > > > -- > Regards > > Robert Campbell > +61412062971 > robcampbel...@gmail.com >
