What is the purpose of UPDATE STATISTICS?
Answers were Sorted based on User's Feedback
Answer / guest
Updates information about the distribution of key values for
one or more statistics groups (collections) in the specified
table or indexed view.
Is This Answer Correct ? | 8 Yes | 3 No |
Answer / sambashiva
This is used after inserting huge rows into table or deleting from a table the pages of the index will be not in the proper way so by running this thing we can bring them to proper way.
Is This Answer Correct ? | 0 Yes | 0 No |
What is table join?
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks
Explain following error properties?
What is it unwise to create wide clustered index keys?
Do you know what are the steps to process a single select statement?
‘Order by’ is not allowed in a view how can you sort information from a view?
What is transact-sql ddl trigger?
What is the difference between NOROW and LOCKROW?
0 Answers Accenture, Honeywell, Satyam,
how can i store resumes in database?
Without Using Cursors , How to Select the Selected row??
3 Answers CarrizalSoft Technologies, Wipro,
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation