The old server (slow server):
Logical CPU : 2
Physical CPU : 1
Physical Memory (MB) : 3071
File Name Total Size in MB Available Space...
The update queries are the same based on the same data stored into the table ADCOSDT. When I display the execution plan, all access are on indexes,...
I don't clear the cache after the exections and the main tables have :
ADCOSDT : 1024 rows (2x512)
Adad : 281961 rows
ADConta 281665 rows
We have a something special with the logical reads on a update query.
We prepare some records (512) into a physical temporary table. The...
Separate names with a comma.