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

Explain about unique identifier data type in sql server?

0 Answers  

---

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

5 Answers   Wipro,

---

Explain sql server authentication modes?

0 Answers  

---

What is normalization of database? What are its benefits?

0 Answers  

---

How can we delete a table in sql server?

0 Answers  

---

Why would you call update statistics?

0 Answers  

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

What is policy based management (pbm)? : sql server database administration

0 Answers  

---

Explain the etl (extraction, transformation, and loading)?

0 Answers  

---

Why do we use functions?

0 Answers  

---

What is a materialized view?

3 Answers  

---

What you can do to delete a table without the delete trigger firing?

0 Answers  

---