what is analyze command ? what kind of statistics does it
generate?
Answers were Sorted based on User's Feedback
Answer / mr. chandra
analyze command is used to check the statics of the query
and performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / brahma prakash
It Analyze the cost of the query with shortest excution path
| Is This Answer Correct ? | 0 Yes | 0 No |
How to select some rows from a table in oracle?
How to handle a single quote in oracle sql?
What is the difference between pre-select and pre-query?
How to run queries on external tables?
How to call a trigger inside a stored procedure?Give an example.
Tell me New Feature of Oracle 10g?
What is the difference between view and materialized view in Oracle?
How to do a full database export?
How to synchronize 2 schema's objects?
What are Clusters ?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is the purpose of tables, private synonyms and public synonyms in Oracle?