How to Test a Query Using a New View

This is just a normal view. It will still store the pages, just for the tables. So any query that uses those tables, whether its using a vew or not,. an can re use that stuff in the memory, in the buffer pool. This can make a huge difference in performance and make performance much faster when you're running a queryanYou want to test, hey, am i having to go read pages from a really easy way to do this in your management studio window is to set statistics io on.