>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.

Paul,

Create another [regular] index with tic_ticket as the key, and Rushmore will use that index to locate your record.

BOb