Product Documentation

c-treeACE V10.0 Release Notes

Previous Topic

Next Topic

Correct Results from Nested TOP Queries and ORDER BY Clause

A query with a subquery using TOP and ORDER BY on an indexed field returned an incorrect result. It was found that a sort optimization did not properly track that an index could have been used to perform the sort. An optimization routine has been adjusted to take into account all available indexes for proper sort ordering.

TOCIndex