Aug 14, 2019 02:25 PM|Mikesdotnetting|LINK
No. I don't think there is much chance of a significant difference in speed of execution. If there was, all the professional advice would be to include extra foreign keys in tables in case you wan to join them directly. I have never seen any advice like
that, so I have no reason to believe that there is any advantage at all in this kind of approach.
The only time I have ever seen anything like this was in a database that was very badly designed to begin with. It's a workaround at best, not a solution.