Programmers only, New ORDER BY information, Part 2

The impact of using the RANDOM index option on ORDER BY sort avoidance

From the developerWorks archives

Bonnie Baker

Date archived: March 7, 2017 | First published: May 02, 2011

Bonnie Baker helps you hone your SQL skills for DB2 for z/OS. In this column, she reviews sort avoidance concepts and sheds light on the costs and benefits of the RANDOM option for indexes.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.

Zone=Information Management
ArticleTitle=Programmers only: New ORDER BY information, Part 2