News for hackers. Stuff that matters.
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.
Re:My startup is Microsoft-based, here's why by Retric on Monday July 01, 2013 @01:27PM (#5972154)
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.