>>If you don't have an index, VFP will have to scan whole table regardless what you do. DELETE-SQL will be even slower because it'll lock/unlock each record.
>>
>If I add the index, what would be better?

USE mytable EXCLUSIVE
SET ORDER TO TAG whatever
LOCATE 
DELETE WHILE tEntered_Date < ldCutoffDate
PACK