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 |
What are the execution control statements?
What are oracle functions?
Can Multiple instances be run on Single Machine???
How to install oracle odbc drivers?
What is a read only transaction in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
What is oracle in java?
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
Explain a synonym?
What is the scope of a local variable?
wirte the syntax of update query?
difference between bind variable and variable