5 min listen
when indexes are useless | The Backend Engineering Show
when indexes are useless | The Backend Engineering Show
ratings:
Length:
27 minutes
Released:
Oct 30, 2021
Format:
Podcast episode
Description
head to https://database.husseinnasser.com to get a discount coupon for my Introduction to Database Engineering course
In this episode of the backend engineering show, I’ll discuss three instances where indexes can be useless and might add overhead to your operations. Let us discuss.
0:00 Intro
1:34 What is an Index?
4:00 The Cost of Indexes
6:40 Most values are the similar
13:00 WHERE UPPER(NAME)=‘RICK’
17:10 Composite Index
23:00 How do I know if I’m using an Index
In this episode of the backend engineering show, I’ll discuss three instances where indexes can be useless and might add overhead to your operations. Let us discuss.
0:00 Intro
1:34 What is an Index?
4:00 The Cost of Indexes
6:40 Most values are the similar
13:00 WHERE UPPER(NAME)=‘RICK’
17:10 Composite Index
23:00 How do I know if I’m using an Index
Released:
Oct 30, 2021
Format:
Podcast episode
Titles in the series (100)
Episode 16 - TheDragon fights Engineers too by The Backend Engineering Show with Hussein Nasser