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 many sql ddl commands are supported by 'mysql'? : Sql dba

function can return value ,procedure also return value through out parameter then what is the difference?

How to avoid using cursors?

what is an extent ? : Sql dba

What is the difference between the Primary and Foreign key?

How do you update a sql procedure?

Is left join faster than inner join?

Write an sql query to select all records from the table?

Why is theta join required?

What is primary key secondary key alternate key candidate key?

What is the difference between the conventional and direct path loads? : aql loader

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

For more SQL PLSQL Interview Questions Click Here