Product Documentation

c-treeACE V10.3 Release Notes

Previous Topic

Next Topic

SQL - Wrong selectivity calculation for unique index with multiple components; last operator Not EQ

The optimization logic was incorrectly calculating the selectivity for a given index with given values (when specified) and a given operator. It contained an optimization for unique indexes when all index components were used and all operators were EQ (since only 1 row matches in this situation). The optimization logic has been modified to correct this situation.

TOCIndex