Product Documentation

c-treeACE V10.0 Release Notes

Previous Topic

Next Topic

Optimize c-treeACE SQL Left Outer Joins to Inner Joins When Applicable

A query was reported that contained multiple outer joins ran very slowly for some values of query criteria. It was observed that the join conditions could allow some of the joins to be converted to inner joins, greatly reducing the number of records to be read. This optimization is now taken when the appropriate join conditions exist.

TOCIndex