Wow ! Do you have an index on CRM_JOB_ITEMS.PK_JOB_ITEMS ?
On 16/04/2015 10:29 a.m., Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > @Rob: Your SQL is taking 28 seconds... > > > > On Thursday, 16 April 2015 3:56 AM, "Robert martin r...@chreos.com > [firebird-support]" <firebird-support@yahoogroups.com> wrote: > > > Hi > > Try replacing your IN statement with an EXISTS clause. Something like > > CRM_DOCUMENT_HEADER.DOCUMENT_TYPE = 1 AND EXISTS(select PK_JOB_ITEMS > from CRM_JOB_ITEMS where PK_JOB_ITEMS = CRM_DOCUMENT_ITEMS.FK_JOB_ITEM > and FK_JOB = '{8BDDED49-8509-48C1-A169-B7E68A74C230}' ROWS 1) > > Cheers > Rob >