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 |
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
Explain the use of rows option in imp command.
How to establish administrator authentication to the server?
Explain what are the type of synonyms?
What is meant by joins? List out the types of joins.
what is Table ?
What is mean by Program Global Area (PGA) ?
What is set verify off in oracle?
What is difference between truncate and delete?
Does facebook use oracle?
How to define a cusotmer as a supplier in ORACLE R12
what is the syntax of CREATE command?