Redundant Grandparent Foreign Keys and Cardinality Estimate Errors

(John Brady) This post is about how a slightly de-normalized database design involving redundant foreign keys to other tables can end up producing sub-optimal execution plans for queries that use those extra joins as additional filter conditions.

Read More – Register for a Membership
Read More (Community content)