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

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

967


What does asynchronous call backs means?

1069


what are the new features introduced in sql server 2000? : Sql server database administration

870


What is recompile sql server?

988


What are dml (data manipulation language) statements in ms sql server?

923


What is a field in a table?

979


What are the types of ssrs?

139


What is enhanced database mirroring in sql server 2008?

912


How to add more data to the testing table in ms sql server?

995


What is t-sql script to take database offline – take database online.

1021


What are statistics?

946


Write a SQL query in order to merge two different columns into single column?

988


What is table valued function and scalar valued functions?

983


Explain what is use of dbcc commands?

987


What are different types of statement?

942