what is analyze command ? what kind of statistics does it
generate?
Answer Posted / brahma prakash
It Analyze the cost of the query with shortest excution path
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Explain the use of record option in exp command.
What is Undo Management Advisor in Oracle?
What are the advantages of oracle 12c?
How to connect to a local oracle 10g xe server?
How to check the oracle tns settings?
What is index in Oracle?
How to connect ms access to oracle servers?
How to get a list of all background sessions in the database?
How to drop an existing view in oracle?
What is recovery manager in Oracle?
What are the major difference between truncate and delete?
How to use "in" parameter properly?
What is PL/SQL ?
Why is oracle so popular?