adspace


Why would you call update statistics? : sql server DBA

Answer Posted / Rajeev Kumar Ranjan

Update Statistics is called to maintain the statistical information about a table or index in SQL Server. It helps the Query Optimizer make better decisions regarding query execution plans, especially after large data modifications or when the statistics become stale.

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 the last version,the release date of that version and fix pack of ibm db2 udb?

2059


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2717


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2187