Useing Analyze & Explain Plain

Hai..

Any one help me to use Analyze and Explain Plain...

I don't know how to use these Options...

Thanks in Advance

RTM

your so unhelpfull abhaysk ;)

Analyze - it analyzes stuff
Explain Plain - explains stuff

simple eh?

Quote:

---

Originally posted by mrchrispy
your so unhelpfull abhaysk ;)

---

am always so :cool: ;)

histogram is the metadata.
ie, data (distribution) about your tables, columns and indexes.

when you analyze these objects your metadata gets updated.

oracle builds its execution plan for SQLs that
operate on these objects based on this metadata.

explain plan shows you the execution plan.

if the data distribution has changed considerably,
you need to analyze.

all the best!

Thanks rajabalachandra..

Can u give the syntax please...

that's a RTFM is ever there was one, just look up analyze in the manual ffs.

oh and remember to eat a couple of times a day and go to the toilet.....or will you need help with that?

Hmmm... Thomas Kyte advices to use "DBMS_STATS" in stead of "ANALYZE"...

You can use "desc dbms_stats" to find the parameters...
for more info : http://tahiti.oracle.com

Quote:

---

Originally posted by efrijters
Hmmm... Thomas Kyte advices to use "DBMS_STATS" in stead of "ANALYZE"...

---

9.x has some bugs with DBMS_STATS

Quote:

---

Originally posted by abhaysk
9.x has some bugs with DBMS_STATS

---

A rather sweeping statement that -- do you mean it shouldn't be used in 9i?

Quote:

---

Originally posted by slimdave
A rather sweeping statement that -- do you mean it shouldn't be used in 9i?

---

Can be used but if u use "FOR ALL INDEXED COLUMNS" clause, then you would get Avg_Row_Length as 100..iresspective of whatsoever.