BEST Indexing explanation video on UKposts

This is far and away the best indexing video I have watched. Every other one barely goes into how indexing works under the hood, or use analogies that don't really make sense. Keep up the awesome content!

recap: 7:08 full table scan 12:26 binary search 13:56 we shouldn't add index at everything

Now i understand this system design term... Please make more videos on cool stuffs like this.

Finalyy a tut that really explains what indexes are... The only one till now. Than you!

This video explained indexing so simply that I can't forget it ever!!!

Great explaination, can you do B-tree and Hash in DB Indexing?

great tutorial bro, keep it up, good luck to your channel !!

Study it tooo long ago, recently my boss put me on the spot with ‘what is an index in db’ haha. Now I know, thanks mate. Good video

whoa! fantastic lesson! More content please!

Hands down the best tutorial on index❤

Super informational! Thank you.

Very good tutorial. Thank you.

Very well explained. Thanks for that

This was so helpful. Thank you!

best video so far

Now i understand this system design term... Please make more videos on cool stuffs like this. also Tsm

Wow you made this easy. Great video

Quality lecture. Thanks...

More on the performance hit of indices on WRITES. How does it work? Does it: A. Insert the new row in the TABLE (O(1)). Find where the index should be placed (O(logn)), insert it there (O(1)). Or does it: B. Insert the new row in the TABLE (O(1)). Query the whole TABLE again (constant). Sort it again (O(idk)). Save it in the index (O(1)). --- I'm guessing A, but I'm not even sure if that's possible lol. I guess the "finding where the index should be placed" would be the slow part and most likely it would be equivalent as doing the same SELECT query for that column as well? Since you mentioned that SELECT is O(logn): Essentially writes would be O(logn). Would that be, correct?

Awesome, thank you.

Fantastic. Thank you very much.

Hands down best video

This was a solid explanation

Laith, Please do a course on Database Please. Please. PLEASE

can you do something like this for mongoDB?

great tutorial!

Amazing!!!😍

Thank you !

Excellent🥳

Best video on Indexing

thank you so much

thank you very much :)

Is this somehow how it works in Windows when it indexes files for file search?

You explained the unexplainable, that calls for the glock glock 3000

i was watching happily till i read the title

But you don’t have to call me dumb though this is already enough 😞

If i understand by this video, am i dumb ?

I don't usually subscribe, but ...

DUMP? Well,....

As a dumb developer I must say I didnt understand.

I hate that you couldn't cut a wait from the animation...