What you’ll learn in this Chapter
✓ Understanding Indexes
✓ Importance of Indexes in database
✓ Types of Indexes
✓ What is Query Explain plan
Overview
Index is a schema object which contains an entry for each value that appears in the indexed column(s) of the table or cluster. Index provides direct, fast access to rows.
This chapter describes the kinds of Indexes that can be applied to table columns to make your database perform better.