A good article.  I think one small oversight is the use of "Covering Indexes" - if I am using the correct term.

The concept is using a composite index to return columns directly [from the index] rather than requiring a separate operation to perform a "bookmark lookup".  A bookmark lookup can be rather costly in certain scenarios.

On one occasion I have used this technique to avoid disc thrashing on a certain large table.