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 convert .db (extention) database file into .dmp (extention ) for oracle database ?
How to use regular expression in pattern match conditions in oracle?
What is a nested table and how is it different from a normal table?
How to rename an index?
What is a recycle bin in oracle?
Explain how are indexes update?
What is bulk load in oracle?
What is STATSPACK tool?
How to run create database statement?
Why does Oracle not permit the use of PCTUSED with indexes?
What is a package ? What are the advantages of package ?
What is the parameter mode that can be passed to a procedure?