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

Who developed sql server?

922


What are different types of statement?

992


How do you delete duplicate rows in sql server?

945


How to write a query with an inner join in ms sql server?

1026


Can you type more than one query in the query editor screen at the same time?

992


What are the methods used to protect against sql injection attack?

1049


Explain about analysis services?

1036


What are indexes in ms sql server?

1041


What is the need for group functions in sql?

1061


How do I install sql server?

876


Difference between 2NF &3NF ?

1071


What are the 7 disadvantages to a manual system?

966


what's the difference between a primary key and a unique key? : Sql server database administration

925


Is foreign key unique?

986


What is transaction server distributed transaction?

1025