"When in doubt, explain" is what i loved about this video.
Dude I appreciate this video, I had two days to try to understand via Copilot, but I was able to catch, that the index sped up the analysis. I thought that I would have another column with numbers, and I needed to use those numbers to filter the search. Now is clear how it works. Thanks a lot!!!
Someone that talks sense. Great info!
This video helped me a lot to understand SQL indexing as a beginner, thanks.
I had table without index took 18 hours to run, with index took like 6 minutes. Table had millions of entries. Also made some changes to my code, but that only shaved like 1-2 hours off.
Great video 🎉 you are just teaching Not only for CRDB but Sql dbs in general 👍
Wow....Ok so I work int he Oracle and SQL DB's a;; the time and yes moving big data and queries this gives more clarity on how to manage thisngs.
Thanks, I learned something valuable from this.
Beautifully explained, thank you!
Thanks! This was a nice enlightening explanation!
Underrated video. Thank you.
You're amazing bro !
Would it not have been more efficient to create a separate table for the city column with additional information about the city such as region and country and reference that by Id and then index based on that instead and additionally have less redundant data or how?
thank you very much, very helpful
At 0:55 sqlite doesn't support this 😭😭
Congrats. The video also helped me. THANKS !!!!!
Very helpful, thank you!
You didn't mention which index you created ? Clustered or non Clustered?😊
Hello man, God bless your efforts. I have a simple enquiry as a new sql learner. How does the term b-tree relate to the index function in sql? Thanks for taking care of this.
@cockroachdb