---
title: "When is the UPDATE_STATISTICS command used?"  
description: "When is the UPDATE_STATISTICS command used?"  
author: "Anonymous User"  
published: 2014-10-12  
updated: 2020-09-22  
canonical: https://www.mindstick.com/interview/2212/when-is-the-update_statistics-command-used  
category: "mssql server"  
tags: ["database", "mssql server"]  
reading_time: 1 minute  

---

# When is the UPDATE_STATISTICS command used?

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.

## Answers

### Answer by Anonymous User

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.


---

Original Source: https://www.mindstick.com/interview/2212/when-is-the-update_statistics-command-used

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.