Re:My startup is Microsoft-based, here's why
by seanc722 on Monday July 01, 2013 @12:36PM
(#5971749)
Have any resources that explain Views and the efficiency vs a query..? I thought views had the same performance of the underlying SQL statements.
[ Parent
| on HN ]
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.