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.