Problem: I noticed that in InterBase 5.0, I now can see information about sorts in the query plan. Is this just info displayed or does the optimizer consider the costs of sorting when it figures out a strategy for executing a query? Solution: /*******************************************************************************/ Note: The information in this article applies to InterBase v5.x /********************************************************************************/ Yes, the optimizer does consider the cost of sorts when devising the plan for running a query. In general terms, it always has taken the cost of sorts into consideration. Certain features have been upgraded to use an index such as count, max , and min.
Last Modified: 26-OCT-00