Week 11 Topic – Performance and Indexes

Topic – Performance and Indexes

Reading

http://en.wikipedia.org/wiki/Database_index – The main Wikipedia article on indexing is very good and quite thorough. You should have a handle on clustered vs. non-clustered indexes.

http://msdn.microsoft.com/en-us/library/dd171921%28v=sql.100%29.aspx – Using Materialized (or indexed) views is a solid way to increase database performance. This is covered very well in this article.

Reference – http://msdn.microsoft.com/en-us/library/ms188783%28v=sql.105%29.aspx – CREATE INDEX syntax and documentation for SQL Server

Reference – http://msdn.microsoft.com/en-us/library/ms178071%28v=sql.105%29.aspx – Documentation for SQL Server execution plan

Lectures

Lecture – Monitoring Database Performance

Lecture – Database Indexing

Assignments

Go to Assignments