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: July 28, 2016 | 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 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.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=650754
ArticleTitle=Programmers only: New ORDER BY information, Part 2
publish-date=05022011