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

What is create command?

931


What is raiseerror? What is raiseerror?

1069


in the physical file layout, where should the transaction log be stored in relation to the data file?

943


Can we use where and having clause together?

981


What is user-defined inline table-valued function?

900


What is 3nf normalization?

928


Where is trigger in sql server?

992


What is ems sql management studio? : sql server management studio

1039


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

982


Explain how you can deploy an SSRS report?

137


explain different levels of normalization? : Sql server database administration

932


What is change tracking in sql server?

945


How do I find the sql server instance name?

922


How real and float literal values are rounded?

1096


What is bulkcopy in sql?

903