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

Hi Bob,

I'm not sure if this is right or not but I have put the .not.deleted() filter on all of my candidate indexs. Is this a wise thing to do? If so, would it be wise then to create a regular index for each candidate index?

TIA,
Paul