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
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what is the use of recording information about current session?
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 is the diffrence between core dba and apps dba?
What is dbcc? : sql server DBA
What is a correlated sub-query? : sql server DBA
how can you implement fine-grained auditing?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what is grd?
Why does Oracle not permit the use of PCTUSED with indexes?
What are the steps you will take to improve performance of a poor performing query?
how can you communicate with operating system files from oracle?
which background process invoke at the time of upgradation tell me???
What is the importance of a recovery model? : sql server DBA
what are the performance views in an oracle rac environment?