SQL Performance (MOSC)

MOSC Banner

What is disjunctive subquery unnesting

edited May 23, 2013 12:46AM in SQL Performance (MOSC) 6 commentsAnswered

Hello. I'm Yuji.
I'm reading Note#15935253.8. It's about "Bug 15935253  Wrong results from disjunctive subquery unnesting"

But I cannot understand this note because I cannot find any friendly description about disjunctive sub-query unnesting.
What is disjunctive sub-query unnesting?

I read some document to understand disjunctive sub-query unnesting.

disjunctive sub-query unnesting transform query which use OR-conditions and sub-query to UNION-ALL query.
What is difference between or-expansion and disjunctive sub-query unnesting. I think both function are very smiler.


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center