what is analyze command ? what kind of statistics does it
generate?

Answers were Sorted based on User's Feedback



what is analyze command ? what kind of statistics does it generate?..

Answer / mr. chandra

analyze command is used to check the statics of the query
and performance.

Is This Answer Correct ?    0 Yes 0 No

what is analyze command ? what kind of statistics does it generate?..

Answer / brahma prakash

It Analyze the cost of the query with shortest excution path

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

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"

7 Answers   British Telecom BT,


Explain the use of rows option in imp command.

0 Answers  


How to establish administrator authentication to the server?

0 Answers  


Explain what are the type of synonyms?

0 Answers  


What is meant by joins? List out the types of joins.

0 Answers  






what is Table ?

2 Answers  


What is mean by Program Global Area (PGA) ?

9 Answers   Bajaj,


What is set verify off in oracle?

0 Answers  


What is difference between truncate and delete?

0 Answers  


Does facebook use oracle?

0 Answers  


How to define a cusotmer as a supplier in ORACLE R12

0 Answers   Intelligroup,


what is the syntax of CREATE command?

8 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)