Link to home
Start Free TrialLog in
Avatar of motioneye
motioneyeFlag for Singapore

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 ?
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of motioneye

ASKER

Thanks Pawan :)
Glad to help!