A view is not compiled. Its a virtual table made up of other tables. When you create it doesn’t reside somewhere on your server. The underlying queries that make up the view are subject to the same performance gains or dings of the query optimizer. I’ve never tested performance on a view VS its underlying query, but i would imagine the performance may vary slightly. You can get better performance on an indexed view if the data is relativley unchanging. This may be what you are thinking maybe in terms of “compiled”. Search indexed views in BOL.