how will u find statistics of a database objects?

Question Posted / pgnath

Answers were Sorted based on User's Feedback

how will u find statistics of a database objects? ..

Answer / ramesh kotha

exex dbms_stats.gather_table_statistics
('<schema>','<tablename>');

Is This Answer Correct ?

1 Yes

0 No

how will u find statistics of a database objects? ..

Answer / senthil vinayagam

Using analyze command

Is This Answer Correct ?

2 Yes

2 No

More SQL PLSQL Interview Questions

How does left join work in sql?

What are the steps you take to tune(performance tuning) the code in plsql?

Can variables be used in sql statements?

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

What is a constraint?

How many clustered indexes can be created on a table?

how can we know the number of days between two given dates using mysql? : Sql dba

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

how can i create a user defined datatype

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

What are operators available in sql?

What is CYCLE/NO CYCLE in a Sequence?

For more SQL PLSQL Interview Questions Click Here