How can you gather statistics on a table?

Question Posted / guest

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

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

0 Answers

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers

Name two files used for network connection to a database.

5 Answers

what is ora 600?

1 Answers

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

2 Answers

How to start SQL Server in minimal configuration mode?

1 Answers

What is the difference between clustered and non-clustered index? : sql server DBA

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

Give the reasoning behind using an index.

2 Answers

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers

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

0 Answers

How would you determine the time zone under which a database was operating?

2 Answers

For more DB Administration Interview Questions Click Here