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.
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
