Transitivity
Oracle CBO performs transitivity as the first step in optimization. Transitivity means generating additional predicates based on existing predicates. The main advantage is the inclusion of extra access methods. Transitivity is not done for join predicates. Assume A, B, and C are columns. If A=5 and A=B, you can conclude that B=5. This can be […]