That's brilliant. It makes perfect sense when you put it like that.

Thanks for the extra detail - it's much appreciated. 🙂

So although it could be argued that I was correct, any query that uses the view would create a cached execution plan in the same way that it would if...