How can you gather statistics on a table?

Question Posted / guest

3 Answers
17618 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

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

0 Answers

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

0 Answers

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers

Hot backup procedure?

2 Answers

Oracle 11g new features?

2 Answers

How do you add a data file to a tablespace?

3 Answers

If we issue alter database begin backup. What happens to database?

2 Answers

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers DELL, TCS,

What is a system database and what is a user database? : sql server DBA

0 Answers

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers

deleted of control file how will u recover control file?

4 Answers CTS,

how will u see whether the dabase is in archive log mode or not?

2 Answers CSC,

For more DB Administration Interview Questions Click Here