what is analyze command ? what kind of statistics does it
generate?

Answer Posted / mr. chandra

analyze command is used to check the statics of the query
and performance.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between a primary key & a unique key?

590


what are actual and formal parameters?

596


What is recovery manager in Oracle?

591


how can we store any pdf file in oracle

1642


What are the various oracle database objects?

676






How to synchronize 2 schema's objects?

1690


What is an Oracle index?

1177


How to use subqueries with the in operator using oracle?

612


How to open and close an explicit cursor in oracle?

577


What is a user account in oracle?

627


How to use null as conditions in oracle?

582


What is varray?

587


What is raw datatype in oracle?

583


Explain the use of indexes option in imp command.

566


Write a syntax for update query in oracle?

620