SQL Performance Explained by Markus Winand

Chapter 1: Anatomy of an index A lookup can be slow even with an index. An example of this is the Index Range Scan. In this, the database reads a large part of the index. If the table is accessed to lookup the rows that are read from the index, even ...