Nonclustered index performance

The query in Figure 9-8 requires the following I/O:

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