Massively Speed-Up SQL Queries with Indexes

Подписаться 372 тыс.

Просмотров 9 тыс.

50% 1

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/

Опубликовано:

1 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 21

@Luc1an_ Год назад

Your videos help a lot during project implementation💫

@adwaitchavan6638 Год назад

I am inspired by your consistency 🔥🙌

@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 !

@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.

@M3MYS3LF1979 4 месяца назад

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

@elgeempire493 Год назад

Interesting thx a lot

@paulthomas1052 Год назад

Thanks - very useful demo. 👌

@tony99659 Год назад

NeuralNilce channel never misses! awesome content!

@pablo20237 Год назад

Thank you sir

@higiniofuentes2551 11 месяцев назад

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!

@higiniofuentes2551 11 месяцев назад

Thank you for this very useful video!