August 21, 2012 at 5:47 pm
I don't have a clear picture on how update statistics works internally but let's say i perform an update statistics on whole table do i still need to perform update statistics on individual columns in a table...Also let's say i have 5 columns in included column index, Is it advisable to have update statistics of all those columns together???
Thanks,
Pradeep
August 21, 2012 at 6:28 pm
What is your setting for sp_autostats ?
from the help file
Displays or changes the automatic statistics update option, AUTO_UPDATE_STATISTICS, for an index, a statistics object, a table, or an indexed view.
August 22, 2012 at 3:27 am
If you update the statistics for a table, it updates all the statistics associated with that table.
No, I wouldn't create or maintain individual statistics except in rare cases for tuning queries when you can't add indexes to a table for whatever reason.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply