|
-
Well, not really. Sometimes you'd get multiple lines of the SQL being implemented as a single step in the explain plan, and sometimes the reverse.
Yopu have to recognise that the SQL (being a 4GL) is a statement of what result set you want, and the explain plan is like a procedural pseudo-code for how the optimizer is going to get that result for you, so you shouldn't expect a close correlation.
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
|