Massively Speed-Up SQL Queries with Indexes

[@tony99659]

NeuralNilce channel never misses! awesome content!

[@Luc1an_]

Your videos help a lot during project implementation💫

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

[@adwaitchavan6638]

I am inspired by your consistency 🔥🙌

[@arghavanasghari3379]

Your are incredibly talented 😊

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

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

[@higiniofuentes2551]

Thank you for this very useful video!

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

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

[@MinecraftJesusGaming]

I gotta review SQL again

[@yuttijon]

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

[@thunderskull258]

Do python backend series

[@Stopinvadingmyhardware]

Anvil

[@CRP3252]

👍🏾👍🏾

[@alex59292]

first