Hi! Hello! How are you doing? :)

Take a look at this instruction:

Select Sum(B.Field3 - B.Field4);
   From B Left Outer Join A On B.Field1 = A.Field1;
   Where B.Field2 = "SOMETHING" .and.;
         B.Field3 > B.Field4 .and.;
         A.Field2 = "YES" .and.;
   Into Cursor MyTest

1) If I have the following indexes: A.Field1 e A.Field2 - That SELECT-SQL takes 10.5 seconds to has been executed.

2) If I delete the indexes (both), the same SELECT-SQL takes 2.5 seconds to has been executed.

Important: To do this test, I delete all indexes from both table.

Please... Some logical explanation?

[]s