A join index cannot be used to partially cover a query that specifies the TOP n or TOP m PERCENT option.