Answer / guest

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

Answer / sivakumar

That command is used to rebuild indexes on tables, which
can speed up queries. You might want want to do it whenever
a large amount of data has been deleted or added. It can be
complicated to determine whether it is more efficient to do
this, or to just let the statistics rebuild automatically
so, as usual, testing is called for in each individual case
to get optimal performance.

Answer / nscom

There are three scenarios where you need to fire the update
statistics
1. Query execution times are slow.
2. Insert Operations Occur on Ascending or Descending Key
Columns
3. After Maintenance Operations - Operations that change the
*distribution of data" such as truncating a table or
performing a bulk insert of a large percentage of the rows.
More information is here
http://msdn.microsoft.com/en-us/library/ms190397.aspx#UpdateStatistics

Answer / govind

its used to create auto indexes on table. means non
clustred indexes are created on table.which is used to
easily craeted data pages for modification and deleteion.

What are the recovery models for a database?

0 Answers  

---

How to check table values in sql server?

0 Answers  

---

What is rank function?

0 Answers  

---

What is the difference between a clustered index and a non-clustered index?

0 Answers  

---

Which TCP/IP port does SQL Server run on?

2 Answers  

---

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,

---

What is the contrast between sql and mysql?

0 Answers  

---

List few advantages of stored procedure.

0 Answers  

---

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

---

How can you insert null values in a column while inserting the data?

0 Answers  

---

What have included columns when we talk about sql server indexing?

0 Answers  

---

How to truncate a table first before running a package?

1 Answers  

---