Tell me When is the UPDATE_STATISTICS command used?
Submitted by: Administrator- When the processing of large data is done, this command is used.
- Whenever large number of deletions, modification or copy takes place into the tables, the indexes need to be updated to take care of these changes. UPDATE_STATISTICS performs this job.
Submitted by: Administrator
- Whenever large number of deletions, modification or copy takes place into the tables, the indexes need to be updated to take care of these changes. UPDATE_STATISTICS performs this job.
Submitted by: Administrator
Read Online SQL Database Concepts Job Interview Questions And Answers
Top SQL Database Concepts Questions
| ☺ | Explain what are Magic tables in SQL Server? |
| ☺ | Do you know how to send email from database? |
| ☺ | How to search for a string in all stored procedure in SQL Server? |
| ☺ | Explain how to use Linked Server? |
| ☺ | Explain difference between cross join and Full outer join? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
