motioneye
asked on
why sql server only update some statistics in the database ?
Guys,
I choose to run update statistics via maintenance plan, however when the update stats is complete I realized only some of the tables get updated whereas most of the table are not being update as it still keep old statistics update date.
why sql serevr choose this way to update statistics ? and how do force all statistics updates in the db ?
I choose to run update statistics via maintenance plan, however when the update stats is complete I realized only some of the tables get updated whereas most of the table are not being update as it still keep old statistics update date.
why sql serevr choose this way to update statistics ? and how do force all statistics updates in the db ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help!
ASKER