Showing related tags and posts across the entire site.
-
My plan is: Job 1: DBCC REINDEX [Table] x (n = processing tables) - daily Job 2: DBCC REINDEX [Table] x (n = entry tables) - weekly Job 3: DBCC REINDEX [Table] x (n = other tables) - monthly Job 4: DelZeroSift - daily (ref: http://www.mibuso.com/dlinfo.asp?FileID=812 ) Job 5: Update Stats - daily (as...
-
[quote user="DenSter"]You need to keep the statistics on the indexes current though. sp_updatestats will update the index statistics, and in turn will make the query analyzer more accurate. [/quote] Yes, Good statistics are critical to query optimizer. But there are several ways to update statistics...
-
You need to keep the statistics on the indexes current though. sp_updatestats will update the index statistics, and in turn will make the query analyzer more accurate.
-
In optimization subjects there are a few scripts related to sumindex fields optimization. In SQL there are a few scripts (I never tested) to optimize scripts. I also don’t usually run update statistics. I rather prefer to periodically rebuild indexes during night. Large tables I might don’t rebuild every...