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


Please Help Members By Posting Answers For Below Questions

how the indexes are stored in the Oracle Database?

1819


How to generate query output in html format?

637


How to create tables for odbc connection testing?

578


WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1883


Can you create a synonym without having a table?

641






How to loop through a cursor variable?

669


Define oracle database

678


Explain oracle’s system global area (sga).

702


ABOUT IDENTITY?

1650


How to create a testing table in oracle?

637


What are the types of trigger in oracle?

652


What is open database communication (odbc) in oracle?

623


what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2126


How to convert csv to table in oracle?

610


What exactly do quotation marks around the table name do?

626