|
-
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!
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
|