>Tore,
>Does that mean that the following query will then be rushmore optimized?
>
>ie : select prodcode, proddesc from tstokmast where !deleted() order by 1 into cursor c_cursorname?

If SET DELETED is ON, you don't have to add !deleted(), but the index Tore suggests may still help. I think you should avoid !deleted() to make your SQL compatible with SQL Server to reduce your confusion if/when you switch between them.