An Upper Bound on Buffer Size for Join Operation Using Nonclusterd Indexes

We give an upper bound on the buffer size with no page reaccess when the access paths available are nonclustered indexes on the joining attributes. The upper bound implies that there is a method of the join operation which needs at most this number of buffer;