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

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

when indexes are useless | The Backend Engineering Show

Welcome to the Backend Engineering Show podcast with your host Hussein Nasser. If you like software engineering you’ve come to the right place. I discuss all sorts of software engineering technologies and news with specific focus on the backend. All opinions are my own. 

Most of my content in the podcast is an audio version of videos I post on my youtube channel here http://www.youtube.com/c/HusseinNasser-software-engineering 

Buy me a coffee 
https://www.buymeacoffee.com/hnasr

🧑‍🏫 Courses I Teach
https://husseinnasser.com/courses

Technology

Welcome to the Backend Engineering Show podcast with your host Hussein Nasser. If you like software engineering you’ve come to the right place. I discuss all sorts of software engineering technologies and news with specific focus on the backend. All opinions are my own. Most of my content in the podcast is an audio version of videos I post on my youtube channel here http://www.youtube.com/c/HusseinNasser-software-engineering Buy me a coffee https://www.buymeacoffee.com/hnasr 🧑‍🏫 Courses I Teach https://husseinnasser.com/courses

Share when indexes are useless | The Backend Engineering Show

Sign up to save your podcasts

when indexes are useless | The Backend Engineering Show

when indexes are useless | The Backend Engineering Show

More shows like The Backend Engineering Show with Hussein Nasser

Software Engineering Radio

The Changelog: Software Development, Open Source

Software Engineering Daily

The Cloudcast

Talk Python To Me

Soft Skills Engineering

Python Bytes

Y Combinator Startup Podcast

Syntax - Tasty Web Development Treats

Practical AI

The Stack Overflow Podcast

The Real Python Podcast

Dwarkesh Podcast

Big Technology Podcast

Oxide and Friends