div></div><a id="id-1.5.4.13.10.2" class="indexterm"></a><p>
    <em class="firstterm">Constraint exclusion</em> is a query optimization
    technique similar to partition pruning.  While it is primarily used
    for partitioning implemented using the legacy inheritance method, it can be
    used for other purposes, including with declarative partitioning.
   </p><p>
    Constraint exclusion works in a very similar way to partition
    pruning, except that it uses each table's <code class="literal">CHECK</c