Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What about UPDATESTATISTICS ?

Answer Posted / 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.

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

plss anybody specify tha constrian management system in dbms

2151


Why use triggers?

1014


How to create new databases with "create database" statements?

1020


How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1013


How can you know if the row fetched from cursor is still valid in underlying table?

998


How to disconnect from a sql server using mssql_close()?

1109


What are the different types of backups that exist?

1167


How many full-text indexes can a table have?

974


What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1066


How to provide login information for a new odbc dsn?

1052


What is 3nf normalization?

995


What do we have to check in database testing?

1019


How to make a remote connection in a database?

977


Who developed sql server?

939


If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1034