SQLServerCentral » Latest topics
Determining causes for performance difference in queries
Hi,
We have an integration query running at 5am - simple view on 3 tables (2 tables have 4-6m rows) - on some days the client extracts data in 4 minutes and in some days it can be 30-40 minutes.
The base tables being queried are re-built eve
We have an integration query running at 5am - simple view on 3 tables (2 tables have 4-6m rows) - on some days the client extracts data in 4 minutes and in some days it can be 30-40 minutes.
The base tables being queried are re-built eve
No comments:
Post a Comment