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>]]

what is raid? : Sql server database administration

0 Answers  

---

how to find 6th highest salary

0 Answers   Chetak Logistics,

---

How to download and install the scaled-down database adventureworkslt?

0 Answers  

---

What can be used instead of trigger?

0 Answers   ADITI,

---

About Indexed Views? with example? plz reply...

2 Answers  

---

What is query processing?

0 Answers  

---

How to get max 100 values from sql server

7 Answers  

---

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

0 Answers  

---

What does it mean to normalize a database and why would you do it?

0 Answers  

---

Differentiate between mongodb vs. Sql server?

0 Answers  

---

what is spatial nonclustered index

0 Answers  

---

Is truncate autocommit?

0 Answers  

---