>Hi Colin,
>
>>Do you mean that Rushmore doesn't use the index at all or that it just ignores the filter expression?
>
>It doesn't use this index at all. Rushmore can only use indexes that have been created without the FOR clause in the INDEX ON command.
>
>Christof
Thanx Christof. Because of the number of index tags that have this FOR clause I'm assuming the original developer did this mistakenly thinking of the logic of a DELETED() tag for each table.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.