From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Indexing in Oracle 23ai

Indexing in Oracle 23ai - Oracle Database Tutorial

From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Start my 1-month free trial Buy for my team

Indexing in Oracle 23ai

“

- [Instructor] Building on what we know about tables, we'll step into optimizing data performance through the most common columns accessed using indexing. Indexes offer increased performance by letting the database engine identify rows faster by relying on what column requirements there are, versus if it was to scan the entire table. This is especially true in the scenario when joining more than one table based on simple column value-matching. Joining on just the index column data to identify rows that match the criteria of the statement makes more sense. Index access can reduce the number of I/O, aka input/output disk operations, to retrieve data and locate rows quickly by the index rows first. It also offers a way to enforce unique constraints for data integrity and consistency. In Oracle 23c, choosing between B-tree index, bitmap index, or a user-defined index depends on the specific use cases, data characteristics, and the nature of the queries being executed. The most common…

Contents