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

Can we use ddl statements in stored procedure?

How do you optimize a stored procedure in sql?

Mention what problem one might face while writing log information to a data-base table in pl/sql?

What is sql query limit?

i need department wise top 2 employees salary.which logic i will use

What is t-sql? : Transact sql

How to change the order of columns in Oracle SQL Plus ?

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

What language is oracle sql developer?

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

what is Complex index. how to create it?

What are the parameter modes supported by pl/sql?

For more SQL PLSQL Interview Questions Click Here