How can you gather statistics on a table?

Question Posted / guest

3 Answers
17808 Views
I also Faced
E-Mail Answers

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

How would you force a log switch?

4 Answers

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers

What is the difference between online backup & offline backup?

3 Answers CSC,

Describe what redo logs are.

1 Answers

what is ora 24313?what is the procedure to exclude that error?

0 Answers

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers

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

0 Answers

how do see how much space is used and free in a tablespace

2 Answers Genpact,

How would you go about verifying the network name that the local_listener is currently using?

0 Answers

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers EDS,

why Datapump is faster than traditional export and import

4 Answers Mphasis,

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

For more DB Administration Interview Questions Click Here