A Dev Gym Workout

Working with Indexes in Oracle Database

Indexes. They're one of the most powerful and misunderstood aspects of SQL performance. Chris Saxon offers a blog post exploring the purpose of an index, how to create, and choose choose your index type. We follow that up with a number of quizzes to help you get head your around using indexes in your application.
  • Instructor

    Chris Saxon*

  • Estimated Time

    48 Minutes

  • Difficulty

    Beginner to Advanced

Oracle Account Text

You need an Oracle Account to take a workout. Click here to sign up.
Already a member of the Oracle Dev Gym? Click here to get back to work.


Exercise Difficulty Time
How to Create and Use Indexes in Oracle DatabaseNot Provided20
Indexes and Index-Organized Tables (documentation)Beginner20
Quiz on IndexesBeginner2
Quiz on IndexesIntermediate2
Quiz on Descending IndexesIntermediate2
Quiz on Indexing nullsAdvanced2

*About Chris Saxon

Chris Saxon is an Oracle Developer Advocate and quizmaster on Dev Gym. His job is to help you get the best out of the Oracle Database and have fun with SQL! He's also part of the answer team on Ask TOM and creates YouTube videos at The Magic of SQL channel.

More from Chris Saxon