Thought I recognised this: Rather than posting the same question on a different site, why not answer the comments you received on Stack Overflow? https://stackoverflow.com/questions/47992325/join-with-sql-view-taking-more-time-in-sql-2016
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk