Oracle 19c SQL

  1. Home
  2. Docs
  3. Oracle 19c SQL
  4. 12 Indexes in Oracle

12 Indexes in Oracle

What you’ll learn in this Chapter

✓ Understanding Indexes
✓ Importance of Indexes in database
✓ Types of Indexes
✓ What is Query Explain plan


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.


Was this article helpful to you? Yes No

How can we help?