IXSCAN
Short Description
The IXSCAN operator represents an index being scanned
Detailed Description​
The IXSCAN operator represents an index being scanned. Indexes are scanned to provide a stream of row IDs to allow table access. When the proportion of rows being retrieved from the table is low, using indexes access is very efficient.
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.