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

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

Question Posted / mr. chandra

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

Please Help Members By Posting Answers For Below Questions

How to bring a tablespace offline?

1074

Explain an exception?

1005

How to recover a dropped table in oracle?

1054

What is a snapshot in oracle database?

1032

What is an Oracle Instance?

1134

What are the oracle differences between nvl and coalesce

1161

What are the differences between char and varchar2 in oracle?

1184

What is an anonymous block?

1266

defination of bitmap index

2135

How do we display rows from the table without duplicates?

980

What is a named program unit?

1097

How do I connect to oracle database?

1133

What is connection pooling in oracle?

979

What is max rowid in oracle?

1035

Whether any commands are used for months calculation? If so, what are they?

1101