what is analyze command ? what kind of statistics does it
generate?
Answer Posted / mr. chandra
analyze command is used to check the statics of the query
and performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create a new user account in oracle?
What is transport network substrate (tns) in oracle?
How to create a single index for multiple columns?
What are the advantages of oracle 12c?
Explain the use of rows option in exp command.
How to execute the package in oracle?
How to assign values to variables?
How to specify default values in insert statement using oracle?
Use of an integrity constraint is better to validate data. Explain
What are the types of trigger in oracle?
Give the constructs of a package, function or a procedure.
How to increment dates by 1 in oracle?
How to sort output in descending order in oracle?
How to create tables for odbc connection testing?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));