Issues concerning collecting statistics on the indexes of a join index are documented in "Collecting Statistics on Join Indexes" in COLUMN and INDEX Options to Collect Statistics . Also see Using Join Index Statistics to Estimate Single-Table Expression Cardinalities for information about using single-table join index statistics to make cardinality estimates that cannot otherwise be made with the same level of confidence.