analyze statement.

na123

Newbie

Join Date: Mar 2006

Posts: 2

#1: Mar 21 '06

hi all,
can anybody tell me.what is analyze statement in oracle?what is the use of analyze statement and how it helps in explain plan?

second is,what is associate statistics?what is it function? :confused:

« previous question | next question »

Similar Misc bytes

Stored Query vs SQL Statement (insights)
7.3.4 vacuum/analyze error (answers)
EXPLAIN ANALYZE total runtime != walltime (answers)
select statement against pg_stats returns inconsistent data (answers)

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,449 network members.