Force the QE to do a union flip join?

Force the QE to do a union flip join?

book

Article ID: KB0083012

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization -

Description

Is there a query hint to force the QE to do a union flip join?
 

Issue/Introduction

Force the QE to do a union flip join?

Resolution

You cannot force the flip join. QE does union join flip when possible and the compares the plan with the non-flipped plan, then it decides which one is better and uses that one.

You can force QE to not do union join flip but not the other way around.
 
Powered by Wolken Software