Improved JOIN Optimizations when Predicates are Included

A slow query was reported that consumed a large percentage of CPU time. The query contained a JOIN operation with predicates and a where clause with OR-d conditions. It was identified that OR optimization was not taking place if there existed join predicates in a join node. In the case of a JOIN syntax where an ON clause is specified, join predicates always exist. Hence, the condition that checked for the existence of join predicates that disabled OR optimization was removed.