-
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
-
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
your so unhelpfull abhaysk
Analyze - it analyzes stuff
Explain Plain - explains stuff
simple eh?
-
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
-
Originally posted by efrijters
Hmmm... Thomas Kyte advices to use "DBMS_STATS" in stead of "ANALYZE"...
9.x has some bugs with DBMS_STATS
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|