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!!!
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.
@@ShujahaidergamingDoesn's matter with the right index, see it like a cake, without a map you will scan the whole cake, but with the right index, you categorize the the cake with color, taste, volume etc, if the sql statement had a where clause of the the color and taste in it, it only has a small piecie of that cake, and that was the end result so the cake was 100gb but the piece 10 kb, with the right mapping it will only scan the small piece
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?
correct. for data that repeat, what you suggested is the right solution. however, this is an example situation and they are trying to explain how indices are used.
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.
Maybe too late but indexes have to be unique (otherwise there is conflict) and preferably small as he said in the video. And if there is none, having a table mostly sorted by a specific column, like DateTime, naturally speeds up the query
hello I would like to do automation with tools of our codes in my WordPress database but I don't know if these ideas are good and feasible, could you help me understand
Hi Sir, I have a table that consist of 16mil record and it will increase, weekly basis. to retrieve this table in Powerbi it is taking more time get this data from large SQL table. can you suggest any changes on the existing table ? current table doesn't have any indexes.
"When in doubt, explain" is what i loved about this video.
This video helped me a lot to understand SQL indexing as a beginner, thanks.
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!
Great video 🎉 you are just teaching Not only for CRDB but Sql dbs in general 👍
Beautifully explained, thank you!
Underrated video. Thank you.
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.
How it happens . It a alot of margin 6 hours and 6 minutes.
How much data in your table ?
@@ShujahaidergamingDoesn's matter with the right index, see it like a cake, without a map you will scan the whole cake, but with the right index, you categorize the the cake with color, taste, volume etc, if the sql statement had a where clause of the the color and taste in it, it only has a small piecie of that cake, and that was the end result so the cake was 100gb but the piece 10 kb, with the right mapping it will only scan the small piece
Thanks! This was a nice enlightening explanation!
🤟
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.
Very helpful, thank you!
Thanks for watching!
thank you very much, very helpful
Thanks !
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?
correct. for data that repeat, what you suggested is the right solution. however, this is an example situation and they are trying to explain how indices are used.
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.
I think the indexing is for the database be able to do a binary search, that is probably done using a binary search tree, that is a type of b-tree
How many indexes should one add? And how do you know which columns to choose?
Maybe too late but indexes have to be unique (otherwise there is conflict) and preferably small as he said in the video. And if there is none, having a table mostly sorted by a specific column, like DateTime, naturally speeds up the query
hello I would like to do automation with tools of our codes in my WordPress database but I don't know if these ideas are good and feasible, could you help me understand
Hi Sir, I have a table that consist of 16mil record and it will increase, weekly basis. to retrieve this table in Powerbi it is taking more time get this data from large SQL table. can you suggest any changes on the existing table ? current table doesn't have any indexes.
Alter the table syntax an add the index
Cool
We couldn't agree more.
oooooooor create a JSON with the cached results :D
Love this video HATE the name cockroach, disgusting
I felt the same but honestly aren't they just insects like every other? I feel sad for the little critters now lol
@@rainymornings Appreciate your sentiment, still HATE roaches.
Thanks🥲
Glad we could help!