Good Morning all,
I am actually trying to learn as to how and when to use the statistics in SQL SERVER 2008.
CREATE STATISTICS MYSTATS ON HumanResources.Department(DepartmentID) WITH SAMPLE 5 PERCENT; go
Once i do this part of the command, i am not sure where to look for the created statistics. Is there any special table in the sys.tables associated with the Statistics. And as far as I have done my research, i have seen having statistics created on a specific table or an index, Wondering if there is an option to do them, on a specific schema in the database and a specific database as a whole.
Then the next part of the statement would be to update this statistics, I have seen sample update statistics statements, but i am not sure how would i update my previously created statistics, presented in the above CREATE STATISTICS statement.
I want to learn the flow of process that is used in this concept of creation of statistics. The process namely including, create, update, use and drop the statistics.I understand that, this is a long question, at least directing me to any document also would be very helpful.
Thank you all once again.