Answer / rajesh ranjan

Hi

This command is basically used when a large processing of
data has occurred. If a large amount of deletions any
modification or Bulk Copy into the tables has occurred, it
has to update the indexes to take these changes into
account. UPDATE_STATISTICS updates the indexes on these
tables accordingly.

Answer / anand

The UPDATE STATISTICS statement defines the storage
requirements of tables and indexes as well as the value
distribution of columns, and stores this information in the
database catalog.

Syntax
<update statistics statement> ::=
UPDATE STAT[ISTICS] COLUMN <table name>.<column name>
[ESTIMATE [<sample definition>]]
| UPDATE STAT[ISTICS] COLUMN (<column name>,...) FOR <table
name> [ESTIMATE [<sample definition>]]
| UPDATE STAT[ISTICS] COLUMN (*) FOR <table name> [ESTIMATE
[<sample definition>]]
| UPDATE STAT[ISTICS] <table name> [ESTIMATE [<sample
definition>]]
| UPDATE STAT[ISTICS] [<owner>.][<identifier>]* [ESTIMATE
[<sample definition>]]

Can we call stored procedure in view in sql server?

0 Answers  

---

What is data source object?

0 Answers  

---

What is the new security features added in sql server 2016? : sql server security

0 Answers  

---

What are the new data types are introduced in sql 2000?

0 Answers  

---

how to trace the traffic hitting a sql server? : Sql server database administration

0 Answers  

---

How do you troubleshoot SQL Server if its running very slow?

2 Answers   HP,

---

How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers  

---

What are the properties of primary key?

0 Answers  

---

Do you know what is similarity and difference between truncate and delete in sql?

0 Answers  

---

Why union all is faster than union?

0 Answers  

---

What does sql server mean?

0 Answers  

---

Is oracle faster than sql server?

0 Answers  

---