Massively Speed-Up SQL Queries with Indexes

In this video, we learn how to massively speed-up SQL database queries using indexes and how to measure the improvement with Python.
◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾
📚 Programming Books & Merch 📚
🐍 The Python Bible Book: www.neuralnine...
💻 The Algorithm Bible Book: www.neuralnine...
👕 Programming Merch: www.neuralnine...
🌐 Social Media & Contact 🌐
📱 Website: www.neuralnine...
📷 Instagram: / neuralnine
🐦 Twitter: / neuralnine
🤵 LinkedIn: / neuralnine
📁 GitHub: github.com/Neu...
🎙 Discord: / discord
🎵 Outro Music From: www.bensound.com/

[@brucerosner3547]

Mathematically speaking indexes reduce searches by a logarithmic factor. Logs grow very slowly especially for large numbers. For example, the log base 10 of million is 6.

[@Luc1an_]

Your videos help a lot during project implementation💫

[@adwaitchavan6638]

I am inspired by your consistency 🔥🙌

[@tony99659]

NeuralNilce channel never misses! awesome content!

[@higiniofuentes2551]

Wow! in one video you teach how to use a data generator, how to use a database, create a cursor, an index and how to measure time,!
Only a question, how many indexes can be supported by a database until the access time collapsed?
Thank you!

[@M3MYS3LF1979]

Appreciate your tutorial! Immediately actionable advice for a work project 🎉
Please post a github gist or link to a repo for your demo code. Didn't find this video in vidstream or youtube-tutorials

[@MrKleiner]

But what if a new record was added after indexing?
Would it combine the search results from the index and the remaining data or just skip non-indexed stuff ?

[@sargn9624]

Indexing is made to the column. So when you are adding new records, indexed column adds indexed values. So you do not need to index everytime after new records add. By the way the negative way of indexing is if you index all columns in a table, your inserting time increase

[@MrKleiner]

@@sargn9624 Thank you !

[@paulthomas1052]

Thanks - very useful demo. 👌

[@yuttijon]

Hi! Very cool video. Make a video in the same format about Mongodb and Rust. Please.

[@higiniofuentes2551]

Thank you for this very useful video!

[@elgeempire493]

Interesting thx a lot

[@pablo20237]

Thank you sir

[@oladelejoseph2892]

I need your assistance on something
Is there a discord channel we could discuss more there?

[@NeuralNine]

I offer 1-on-1 training / consulting. You can go to the "Services" section on my website and contact me there. :)

[@oladelejoseph2892]

@@NeuralNine alright thanks

[@thunderskull258]

Do python backend series

[@Stopinvadingmyhardware]

Anvil

[@CRP3252]

👍🏾👍🏾

[@alex59292]

first