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
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