>Set deleted is on
>no index on deleted()
>cpdbf() and cpcurrent() are both 1252.
>already indexed on prodcode field.
>What would be the normal query time for 415k records to run :-
>select count(*) from tstokmast.
>I've got 25 seconds.
>Yau
Yau,
As Tore told you, if you SET DELETED OFF the results will be instantaneous.
Regards,
Jim