How can you gather statistics on a table?

Question Posted / guest

3 Answers
17923 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 a correlated sub-query? : sql server DBA

0 Answers

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers

If CPU is very slow What can u do to speed up?

1 Answers

Explain the difference between a data block, an extent and a segment.

2 Answers

what are the types of connection load-balancing?

0 Answers Oracle,

Explain the concept of the DUAL table.

3 Answers

What is the default fill factor value? : sql server DBA

0 Answers

what is difference between user managed backup and rman backup?

1 Answers CTS,

What would you do with an "in-doubt" distributed transaction?

0 Answers

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers

How can you gather statistics on a table?

3 Answers

how can you communicate with operating system files from oracle?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here