Programmers only: New ORDER BY information, Part 2

(Bonnie Baker) In the last issue, I began a series of columns concerning new aspects of ORDER BY. This column—Part 2—covers the impact of using the CREATE/ALTER INDEX RANDOM order option on sort avoidance. It also covers the issue of coding only GROUP BY COL1, COL2 versus coding both GROUP BY COL1,

Read More - Register for Free Membership