Re: Performance with ORDER BY !!!

The only thing /* FIRST_ROWS */ does is encourage the optimizer to choose a nested loop access path.

Granted, the INDEX_ASC suggestion only really works well when the predicate matches (or is a subset of) the sort order. In data warehousing loads or aggregation processes, I frequently care more about moving all rows in sequence rather than narrowing an answer set.

D. Received on Mon Dec 06 1999 - 21:35:02 CST