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 is oracle sid?
what is exact difference between drop and truncate table.
How to use an explicit cursor without open statements?
Can u make a synonym for deptno=10 only from emp table.
How to define and use table alias names in oracle?
Does rowid change in oracle?
difference between oracle8i and oracle9i
What is save point in oracle database?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
Explain self joins in oracle?
WHAT IS ecc 6.0
How to run create database statement?