Views, Indexed Views, and NOEXPAND

Views are a nice abstraction layer, letting us re-use a query multiple times in multiple ways. Indexing them is a way to pay for the work of executing that query up front instead of when we query it. It comes with a cost, but the pay off can be big. Enterprise Edition automatically figures indexed views into it's optimization process, but on Standard you have to tell it do that by adding in the NOEXPAND hint to your query. We've got a longer than usual video that tries to show you enough about each of these concepts to show you how they work together.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Michal on 12/20/2010

Good one, although the subject is not fully explored :)

Stephen on 12/20/2010

Nice explanation of some vague concepts

Tina on 12/20/2010

Very good presentation.

Marcelo Marim on 12/20/2010

Love it... very well done.

Dennis Allen on 12/20/2010

Top notch. I appreciate the extra detail of pointing out that an indexed view is like having a set of triggers on the source table(s) which build a table for the view.

Deepak Kolapkar on 12/20/2010

Hi Andy, This is really a great video with lots of details which even a regulat SQL professional might be missing on. I got some questions on similar case scenarios. Is there any email ID you can be reached at? Thanks

Jamshid Nouri on 12/20/2010

excellent demo

Ron Taylor on 12/20/2010

Excellent summary of Views and Clustered Indexes. I would LOVE a follow-up to this to talk about SQL wizard to know what Views/Clustered indexes should be created based on existing SQL performance!

Ann on 12/20/2010

Very nice presentation. Thank you!!!

Raymond on 12/20/2010

Great. Thanks.

Christina Le on 12/21/2010

Very helpful. Thank you.

Dave on 12/22/2010

Would it be possible to have access to the code?

Jeyakumar on 12/23/2010

Superb video for developers, in terms of performance tuning.

Diana Dee on 12/26/2010

Why do the number of reads decrease on subsequent executions that use the indexed view (unique clustered index or the non-clustered index)? Are those reads from pages in memory? I'd appreciate an answer, or where to look for one. Thanks. DrDianaDee@verizon.net

Martin Miller on 12/28/2010

Great demo. Thanks Andy.

Mohamed Irshad on 1/5/2011

Excellent video. Learnt a lot. Thank you

usha on 1/23/2011

how to download this video....

vamsi on 5/5/2011

very gud session

Chandhini on 6/1/2011

Very useful details for us.

chandrasekhar on 1/11/2012

very good

Michael on 2/8/2012

Excellent