Product Documentation

c-treeACE V10.0 Release Notes

Previous Topic

Next Topic

Improved Query Times with Multiple Operator Support in ANL Joins

A query was found to have its execution time out which contained the following clause:

( table.field IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) )

This IN clause was found to affect performance and it was determined that multiple operators were not allowed on index scans for an ANL join execution. Changes have been made to allow additional ANL predicates resulting in efficient index choices boosting performance.

TOCIndex