We may earn an affiliate commission when you visit our partners.

Database Indexing

Save

May 11, 2024 4 minute read

Database indexing is a technique that improves the speed and efficiency of data retrieval operations in a database management system (DBMS). It involves creating and maintaining special data structures that map the values of one or more columns in a table to the physical location of the corresponding rows on disk.

Benefits of Database Indexing

Database indexing offers several benefits, including:

Path to Database Indexing

Take the first step.

We've curated four courses to help you on your path to Database Indexing. Use these to develop your skills, build background knowledge, and put what you learn to practice.

Sorted from most relevant to least relevant:

Vector Databases Deep Dive

Save

PyMongo - Advanced

Save

Getting Started with Redis and RediSearch

Save

Management of Relational and Non-relational Databases

Save

Help others find this page about Database Indexing: by sharing it with your friends and followers:

Facebook

Copy Link

Reading list

We've selected six books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Database Indexing.

Database Design for Mere Mortals

Save

Provides a comprehensive overview of database indexing, covering the different types of indexes, how to create and maintain them, and how to use them to improve the performance of your database queries.

Database Design for Mere Mortals: A Hands-On Guide...

Paperback

SQL Performance Tuning

Save

Provides practical advice on how to tune the performance of SQL queries, including how to use indexes effectively.

SQL Performance Tuning

Paperback

Object-Oriented Application Development Using the...

Save

Textbook on database management systems in German. It covers all aspects of database systems, including indexing.

Object-Oriented Application Development Using the...

Hardcover

High Performance MySQL

Save

While it general book on MySQL optimization, this book includes practical information on indexing MySQL databases along with other performance-tuning techniques.

High Performance MySQL: Optimization, Backups, and...

Paperback

High Performance MySQL: Optimization, Backups,...

Paperback

(中文) High Performance MySQL ( 3rd Edition ) (MySQL...

Paperback