SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Summary

In this chapter, you learned about indexes and views. First, you explored indexes and learned how they can help to improve the performance of a database when they are properly designed. You also learned about the different types of indexes and how to create them. Index maintenance was addressed as you discovered how to drop, disable, enable, rebuild, and reorganize indexes.

Next, you learned about views and the simplicity they introduce to data access for your users. Views allow you to aggregate data together into a virtual table so that users can more easily access that data. Additionally, views can be indexed to improve the performance of data access.