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 is meant by a deadlock situation?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain constraining triggers.
How to loop through data rows in the implicit cursor?
What is open database communication (odbc) in oracle?
What is the order of defining local variables and sub procedures/functions?
What is transaction control statement and how many types of transaction control statement in Oracle?
How to export data to a csv file?
How to view all columns in an existing table?
What is procedure overloading in oracle?
How to use "if" statements on multiple conditions?
What do you mean by cdb and pdb in oracle 12c?
How to check your oracle database 10g xe installation?
How to convert characters to numbers in oracle?
How to convert csv to table in oracle?