|
|
|
A slow query was identified that did not consider a possible optimization path. OR optimization was improved, ensuring that the execution node restriction was broken down even when there is only one table. Functionality was added to convert OR into UNION, which is beneficial if the cardinality of each ORed predicate is small.
A configuration keyword, SETENV DH_OPT_OR_CARD, was introduced to specify the threshold for this conversion. The default value is 10000.
