Hi nadya,
> I will try. Unfortunately, it was not my decision to include deleted tag in each of our table. I doubt, that I can influence to change it. Also we found lots of other problems with Development server. It's running all queries very slowly, even for the single table.
Well Try the following to prove my statement:
Take the 5 mln table (with a DELETED() tag) and construct a SQL SELECT that should only return one record in which the where clause is based on the primary key (if possible):
SELECT * FROM MyLageTable WHERE My_Pk = MyValue INTO CURSOR Result NOFILTER
Now try it with SET DELETE ON and with SET DELETE OFF.
The first takes a long time to execute, the second should execute almost instantly.
Walter,