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
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.