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: July 28, 2016 | First published: May 02, 2011Bonnie 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 article was originally published in IBM Data magazine.
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.