|
-
So in fact there are at least 25 joins here.
I'm wondering if there's anything that can be done that doesn't require massive restructuring of the db or the views...
Is there anything here that could create some kind of "loop" in the optimizer?
It would seem the 10g optimizer is doing something radically different than the 9i optimizer.
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
|