In this lesson, we talk about indexes, which provide you with a shorter route to your data. So far, you have learned how to create tables, populate tables with data, and select data from tables. Now, how can we get to data faster? By using indexes, which are objects based on data in tables. Unlike views, which we discussed during Lesson 13, indexes do indeed require physical storage. By the end of this lesson, you will understand the following:
• How to create indexes
• How to create composite indexes
• What indexes do
• When indexes should be used
• When it is better not to use an index
An index is a way of presenting data differently than the way it appears on the disk. Special types ...