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...

How can you gather statistics on a table?

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


Please Help Members By Posting Answers For Below Questions

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1059


what is the use of recording information about current session?

1112


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

2165


what is the diffrence between core dba and apps dba?

2624


What is dbcc? : sql server DBA

1355


What is a correlated sub-query? : sql server DBA

1158


how can you implement fine-grained auditing?

1206


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1371


what is grd?

1157


Why does Oracle not permit the use of PCTUSED with indexes?

3020


What are the steps you will take to improve performance of a poor performing query?

2901


how can you communicate with operating system files from oracle?

1096


which background process invoke at the time of upgradation tell me???

2783


What is the importance of a recovery model? : sql server DBA

1083


what are the performance views in an oracle rac environment?

1127