You're right, it works fine with an index. The strange thing is that now without an index it also executes fast. I don´t know what happened before.

Zakaria al Azhar


If Table2 is a table and you have defined a Tag index,
VFP build a structural CDX index.
Everytime you use Table2 VFP open this index automatically.

Try this:

WAIT WINDOW STR(TAGNO('Table2'))
SELECT .....