Why explain plan changes in oracle

Ask Question. Asked 4 years, 9 months ago. Active 4 years, 9 months ago. Viewed 2k times. Improve this question. Also index might be "covering" it means it contains all necessary information and there is no need to touch table blocks. Add a comment.

Active Oldest Votes. Improve this answer. Vijayakumar Udupa Vijayakumar Udupa 1, 1 1 gold badge 6 6 silver badges 14 14 bronze badges. If you want to decide this for Oracle you can use hints. OracleDev OracleDev 1 1 silver badge 7 7 bronze badges. I've tried using hint, and Oracle ignores it. I want to know more about "even when the condition is satisfied, the engine doesn't need to touch the base table; the needed value, of col1 only, is already available from the index", My understanding is that always data block is accessed for row data.

Any pointers for further reading? Sign up or log in Sign up using Google. You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. This site uses Akismet to reduce spam. Learn how your comment data is processed. Predicate Information identified by operation id : —————————————————. You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account.

You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. Please replace these characters in the code sections with the HTML equivalents for these characters:.

Like this: Like Loading Thanks so much once again for starting the blog, really so much happy! Charles Hooper : Thanks for the feedback Aman. Recently I apply patchset What do you think? If it were 11g no parameters would be fine. You do not have to do this gathering of dictionary stats often. Carlos Sierra. Erika, Dictionary Stats? You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account. You are commenting using your Facebook account.

Notify me of new comments via email.