Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Understanding Indexes

Introduction
B-trees
4. The consequences of using indexes
Summary

Instruction

Even though indexes boost the performance of SQL queries, they come at a price – they take up additional space on the hard drive and reduce the speed of data insertion, modification, and deletion. In other words, indexes help you retrieve data faster, but you'll insert, modify, and delete data slower.

Exercise

Click Next exercise to continue.