4 ms·
Have any resources that explain Views and the efficiency vs a query..? I thought views had the same performance of the underlying SQL statements.
by seanc722 13y ago
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 13y agoIn 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 http://technet.microsoft.com/en-us/library/cc917715.aspx Other DB's have there own optimizations for the same idea.