[firebird-support] Speed of an query with IN select

Is there a way I can speed up the following query? Select CODE, STKCODE, DESCRIPTION from COUNT_SHEETS_DETAIL where code STARTING WITH 'TPL' and STKCODE in (Select STKCODE from (Select STKCODE, COUNT(STKCODE) as COUNT1 from COUNT_SHEETS_DETAIL where code STARTING WITH 'TPL' GROUP BY STKCODE ord

Re: [firebird-support] Speed of an query with IN select

cornievs wrote: > Is there a way I can speed up the following query? > > Select CODE, STKCODE, DESCRIPTION from COUNT_SHEETS_DETAIL where code > STARTING WITH 'TPL' and STKCODE in (Select STKCODE from (Select STKCODE, > COUNT(STKCODE) as COUNT1 from COUNT_SHEETS_DETAIL where code STARTING WITH