How can you gather statistics on a table?

Question Posted / guest

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

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers STC,

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

0 Answers

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers

internal architecture

0 Answers CSC,

What is blocking and how would you troubleshoot it?

1 Answers

what is incremental checkpoint?

1 Answers CTS,

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers HSBC,

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

0 Answers

wat is global index and local indes

1 Answers Oracle,

What is the dataguard background process??

1 Answers iGate,

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers

For more DB Administration Interview Questions Click Here