>Naomi,
>When I run sele count(*) from tstokmast, even this took 3 minutes!
>Yau
What is:
1) SET DELETED and do you have an index on DELETED()
2) CPDBF() and CPCURRENT?
Why do you need to select count(*) without WHERE condition?
If it's not broken, fix it until it is.
My Blog