• Chris Bell wrote something on that topic here: https://wateroxconsulting.com/archives/untrusted-foreign-keys/

    It doesn't get into the details of how it can change execution plans which is what I think you're looking for.


    Steve Hood

    Blog: Simple SQL Server
    Twitter: @SteveHoodSQL