community.borland.com

Article #25470: Display of sort info on Query Plan

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