05-08-2017 6:49 PM - edited 02-03-2024 10:39 PM
I'm trying to figure out the difference between these update statistics commands (with descriptions copy/pasted from the documentation. Bold added by me):
Does 'update statistics <table>' update stats for all columns in a table? I think it *doesn't* because "update all statistics" says it does all columns. Maybe 'update statistics <table>' only updates leading index columns? Does it update non-indexed columns?
Does 'update index statistics <table>' update stats for all columns in all indexes in a table? (I think it *does*)
Thanks in advance
Ben
So I ran a quick test and verified the following:
So, yes, your assumptions are true.
I guess my point is the documentation saying:
Is just flat out misleading. I'll create an incident (FWIW).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.