1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

How can you gather statistics on a table?

Question Posted / guest

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

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

1 Answers   Oracle,

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

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

1 Answers  

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

Where do you find the default index fill factor and how to change it? : sql server DBA

1 Answers  

What command would you use to create a backup control file?

2 Answers  

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

why we use cursors

1 Answers  

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1 Answers  

For more DB Administration Interview Questions Click Here
Categories