The INTERNAL SORT hint specifies that the query executor use the internal sorter. Use this hint if the expected result set is small (hundreds of rows as opposed to thousands of rows); for example, if you are performing some aggregates, ORDER BY with small result sets, or GROUP BY with small result sets, and so on.

This hint avoids the use of the more expensive external sorter.