Database Indexes & Performance Simplified

Please support me on Patreon: / thesimpleengineer
/ thesimpengineer
ryan-schachte.com
/ schachte
This video seeks to simplify the idea behind database indexes, performance and different search algorithms used to search through data.
We will cover lots of topics within this short video! Hope you enjoy!
Chapter Topics
----------------------------------------
00:00 Introduction
00:50 Why use an index?
01:52 What is an index?
07:22 Philosophies around indexes
09:38 How to create an index
11:07 Explaining explain and analyze
15:52 Bitmap heap scan & bitmap index scan
18:19 Understanding clustered vs. non-clustered indexes
21:37 Search algorithm high-level overview
25:00 Concluding notes

[@gvgame6857]

Working with this guy has made me smarter just by breathing the same air as him.

[@alexanderbalasky6174]

This channel is incredible. Hoping to see it take off.

[@MrC0pyP4st3]

Glad to see you back!

[@SvenMolhuijsen1]

thank you for this video, it really helped me preparing for a test

[@syedsheheryarumair97]

Thank you for this video. You have explained this concept in a very easy manner.

[@TheDesvendador]

Amazing video quality, I don't fully understand all the concepts yet but I will haha
thanks!

[@ritwizsinha1261]

Great video, subscribed !!!!

[@veronicasmith8322]

Thank you so much! Subscribed.

[@peterarias4165]

Simple. Thank you!

[@sufyanfaris]

You're back!!!!

[@timsteele6517]

continue to make videos they are really good!

[@TheSimpleEngineer]

Thanks Tim!

[@vithunchandra8420]

Holy, this is a very clear explanation

[@TheSimpleEngineer]

Thanks! Glad you enjoyed

[@dleivam]

Brilliant

[@daaneschandrashekar4050]

Thanks

[@M4SSDEBATER]

Nice

[@robertsedgewick1266]

You are back!!

[@TheSimpleEngineer]

THE Robert Sedgewick? ;)

[@robertsedgewick1266]

@@TheSimpleEngineer just his big fan, sorry to disappoint :P

[@divyanshusingh6473]

@@robertsedgewick1266 nice 😹

[@akshaykhanapuri1995]

Hi, Simple Engineer, I am a huge fan of your work. Can you please come up with an episode of Algorithmic mental model on backtracking.

[@TheSimpleEngineer]

Currently working on one!

[@ScottSchulzVlogs]

was that a little easter egg in there for Ryan's salary ;)

[@epicxiphos8269]

I need to know what preschool Gabe went to

[@user-dhb-2662]

Thanks