Nonclustered index performance

The query in Figure 5-8 requires one read for each:

If your applications use a particular nonclustered index frequently, the root and intermediate pages are probably in cache, so it is likely that only one or two physical disk I/Os need to be performed.