Artwork

Content provided by Hussein Nasser. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Hussein Nasser or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.
Player FM - Podcast App
Go offline with the Player FM app!

when indexes are useless | The Backend Engineering Show

27:12
 
Share
 

Manage episode 305914409 series 1954062
Content provided by Hussein Nasser. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Hussein Nasser or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

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

  continue reading

512 episodes

Artwork
iconShare
 
Manage episode 305914409 series 1954062
Content provided by Hussein Nasser. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Hussein Nasser or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

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

  continue reading

512 episodes

All episodes

×
 
Loading …

Welcome to Player FM!

Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.

 

Quick Reference Guide