IXAND
The IXAND operator represents the logical ANDing of rows gained from multiple indexes
Detailed Description​
The IXAND operator represents the logical ANDing of rows gained from multiple indexes. The ability to apply ANDed predicates to multiple indexes minimizes access to underlying tables therefore making queries more efficient.
IXAND is most efficient with single column indexes.
The performance of indexes can suffer over time so consider as they become fragmented so consider recreating or reorganizing busy indexes periodically.
Ensure that statistics are kept up to date with RUNSTATS and if your data tends to skew, consider the use of the WITH DISTRIBUTION option.
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.