Summary

Index creation is an important part of managing your database. Creating useful indexes can vastly improve query performance, but you must also consider the impact that indexes can have on data manipulation and disk space. In the next chapter, "Implementing Data Integrity," you will see how indexes are used to enforce data integrity through constraints, and subsequent chapters will show how to fine-tune your indexes for the best possible performance.