Answer Posted / guest
We can gather statistics on a table through>>
analyze table TABLE_NAME compute statistics , or
analyze table TABLE_NAME estimate statistics
Regards
Abhinav
Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
Where do you find the default index fill factor and how to change it? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the different types of indexes available in sql server? : sql server DBA
how can you initialize log miner?
How do you trace the traffic hitting a sql server? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What would you do with an "in-doubt" distributed transaction?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what is logical system in sap basis
how can you get actual data change values from previous transactions in oracle?
what is ora 24313?what is the procedure to exclude that error?
what functionality does oracle provide to secure sensitive information?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
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
What purpose does the model database server? : sql server DBA