December 17, 2013 at 7:02 am
Hi Team,
We have a table with a 1 column Primary Key on and
an UNIQUE Non-Clustered Index with 16 columns.
This table has more than 20695780 Rows and on every day new records inserted between 30000 and 35000.
After insertion process, we have many other processes those refer this table.
On every day, before proceeding further, after insert we do an Update Statistics with 30 Percent Sample on this table.
After this when we do rest processes then we are not facing problem and everything goes smoothly.
Now the problem is if we do Update Statistics then it is taking more than 15 Minutes.
We need a solution: -
To make this "Update Statistics" faster OR
Can we perform a parallel Update Stats on this table with other processes OR
Instead of "Update Statistics" can we go for REBUILD INDEXES (need to know it will update all Statistics or not)? OR
Any other solution by which we can save this 15 minutes.
Please advice.
December 17, 2013 at 9:25 am
Are you sure that you really need to update the statistics every day?
What problems do you have is you only do the update statistics once per week?
December 17, 2013 at 10:27 am
Hi!
Actually the other processes depends on data of this table are also getting the data on daily basis and the volume is also same and some time on higher side.
When we execute the SPs having this table then those SPs taking more than 40-60 min. and after Update Stats they executed within 5-8 mins. That's the reason to avoid such issues we are updating stats on daily basis after data load.
Please advice.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply