Previous Topic

Next Topic

Distinct Key Count for Improved c-treeACE SQL Query Efficiency

The c-treeACE SQL query optimizer now takes advantage of distinct key counts in an index for improved efficiencies. In some cases, speedups of over 200 fold for selected queries have been reported with this additional index level information. c-treeACE SQL now creates indexes with distinct key count support by default.