Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

SETENV DH_OPT_OR_CARD

An OR clause 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. This keyword specifes the threshold for this conversion

Example

SETENV DH_OPT_OR_CARD=xxx

Default: 1000

TOCIndex