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?

Answers were Sorted based on User's Feedback



How can you gather statistics on a table?..

Answer / santosh

you can use dbms_stats package

Is This Answer Correct ?    19 Yes 3 No

How can you gather statistics on a table?..

Answer / 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

How can you gather statistics on a table?..

Answer / balu

exec dbms_stats.gather_table_stats('ownername','tablename')

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More DB Administration Interview Questions

what do you understand by fine-grained auditing?

0 Answers   Oracle,


How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  


In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  


What are the different sql server versions you have worked on? : sql server DBA

0 Answers  


what is the use of recording information about current session?

0 Answers   Oracle,


how can you process messages in order asynchronously?

0 Answers   Oracle,


how can you communicate with operating system files from oracle?

0 Answers   Oracle,


What is the difference between Datapump & export/import?

2 Answers  


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

0 Answers   iGate,


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  


1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,


What are the different types of indexes available in sql server? : sql server DBA

0 Answers  


Categories