I have a table with 500,000 records. I have a candidate index on tic_ticket with a filter of .not.deleted(). If I use a seek statement: =seek("901500","scticket","tic_ticket"), The record is selected immediately. If I issue a select statement: select * from scticket where tic_ticket = "901500", it takes a long time.

I understand that VFP is trying to optimize the expression and it cannot optimize with the filter. Isn't there a way to tell VFP to use my tic_ticket index and not try to optimize?

I am really struggling with this issue. I am beginning to come to the conclusion that I can't use select statements. But that seems crazy.

Any guidance?

paul