Continue to attempt optimization choices of index for colocated joins even if user have specified explicit index hints for some tables.
Continue to attempt optimization choices of index for colocated joins even if user have specified explicit index hints for some tables.
Note:
user specified index hint will be honored and optimizer will only attempt for
other tables in the query.
Don't alter the join order provided by the user.
By default if query have atleast one colocated join conditions mentioned between a pair of partitiioned tables, optimizer won't try to derive colocation possibilities with replicated tables in between.
By default if query have atleast one colocated join conditions mentioned between a pair of partitiioned tables, optimizer won't try to derive colocation possibilities with replicated tables in between. This switch tells the optimizer to include partition -> replicated -> partition like indirect colocation possibilities even if partition -> partition join conditions are mentioned.
List of possible values for Join Order QueryHint.
Note:
Ordering is applicable only when index choice is left to the optimizer. By default, if user specifies explicit index hint like "select * from t1 --+ index()", optimizer will just honor the hint and skip everything mentioned in joinOrder. In other words, a blank index() hint for any table disables choice of index and its associated following rules.