In case when select is fully Rushmore optimizable foxpro doesn't create cursor but instead opens source table with command similar to USE AGAIN and uses SET FILTER to filter records. Removing index on DELETED() makes select only partialy optimizable. You can add NOFILTER clause to the Select to force foxpro to create a cursor as a temporay file.