Hi Jess,
can you help me to optimize my index in RM tecnology?

thanks.

Vincenzo,

In Foxpro RM the following must be considered:
1. try to avoid EMPTY() functions, instead replace it with :
for Var1 != SPACE(10) && character field (depending on width)
!= { / / } && date type
!= 0 && numeric
2. Set a separate index on deleted rows by issuing below statement on the command statement so that you do no longer include it on your FOR clause part:
Index on DELETED() tag DELETED
3. be sure that SET OPTIMIZE ON is issued on your program...

The above are just partial consideration when it comes RM technology. Please try to read Using VFP 5.0 on the last chapter if I am not mistaken.

There are a lot of considerations why an application seems slowing down. Indexes are just a portion of it. Like for example:
1. we rarely use REPLACE FOR ; we use REPLACE WHILE
2. we rarely use SCAN FOR ; we use SCAN WHILE
ofcourse it should be coupled with the proper Indexes.
We have a client wanted to adopt our Point-Of-Sale System for Dutyfree Supermarket with at least 30 Cash Registers done in FP DOS 2.x, replacing their current system (a very slow) done in PROGRESS system. Why? It is on the design side, not on the Language itself.

4. We do not use FOR conditions in Index expressions. We do use Filters coupled with SET ORDER TO 0 (zero). Again that depends on the situation.