I have 1 table that has 130,000 records. I have an DELETED() tag on this dbf.

With SET DELETE ON, the following query takes 7+ seconds. With SET DELETE OFF, the query takes .25 seconds. Only 1 record is being selected from the table and there is a tag on the part field.

select myfile.part ;
FROM myfile ;
WHERE myfile.part = "440" ;
INTO CURSOR test

SYS(3054, 1) says that the part tag is being used and the deleted() tag is being used and that the optimization level is FULL.

Should this query take 7+ seconds with DELETED ON and .25 with DELETED OFF?

Thanks,

Jerryt