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 is the purpose of UPDATE STATISTICS?

Answer Posted / sambashiva

This is used after inserting huge rows into table or deleting from a table the pages of the index will be not in the proper way so by running this thing we can bring them to proper way.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do database indexes work?

1009


What is instead of dml trigger?

1001


Where cross join is used?

960


How you trouble shoot when any job fails

1937


When would you use a before or after trigger?

907


How to backup SQL Server Reporting Services ?

148


What do you understand by recursive stored procedures?

988


What are different types of statement?

1017


What xml support does the sql server extend?

1011


Can we insert data into view sql server?

927


How to set the current database in ms sql server?

1081


Explain indexed views?

981


What is the difference between a local and a global temporary table?

1118


What are drillthrough reports?

155


What are the purpose of Normalisation?

1050