[seanc722]

Have any resources that explain Views and the efficiency vs a query..? I thought views had the same performance of the underlying SQL statements.

[Retric]

In SQL server normal Views are basically just a select statent but indexed views can have large performance advantages. http://technet.microsoft.com/en-us/library/cc917715.aspx Other DB's have there own optimizations for the same idea.