"When in doubt, explain" is what i loved about this video.
@MagicOfDark
Жыл бұрын
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.
@Shujahaidergaming
5 ай бұрын
How it happens . It a alot of margin 6 hours and 6 minutes. How much data in your table ?
@jeswer9
Жыл бұрын
Someone that talks sense. Great info!
@abhay6276
4 ай бұрын
You didn't mention which index you created ? Clustered or non Clustered?😊
@electrolyteorb
Жыл бұрын
Great video 🎉 you are just teaching Not only for CRDB but Sql dbs in general 👍
@chrisder1814
Ай бұрын
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
@hasanmougharbel8030
2 жыл бұрын
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.
@Deltacasper
Жыл бұрын
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?
@michealraspberry4138
10 ай бұрын
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.
@DavidYoo-m7z
11 ай бұрын
Love this video HATE the name cockroach, disgusting
@rainymornings
10 ай бұрын
I felt the same but honestly aren't they just insects like every other? I feel sad for the little critters now lol
@DavidYoo-m7z
9 ай бұрын
@@rainymornings Appreciate your sentiment, still HATE roaches.
@gregmaier5784
10 күн бұрын
Beautifully explained, thank you!
@umabharathyts1998
2 ай бұрын
Thanks !
@ExcelTutorials1
Жыл бұрын
Very helpful, thank you!
@cockroachdb
Жыл бұрын
Thanks for watching!
@teja6124
Жыл бұрын
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.
@maryadebimpe9424
7 ай бұрын
Alter the table syntax an add the index
@jenweatherwax7113
7 ай бұрын
How many indexes should one add? And how do you know which columns to choose?
@MatheusLB2009
3 ай бұрын
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
@AnatolyLeonov
Жыл бұрын
Thanks! This was a nice enlightening explanation!
@cockroachdb
Жыл бұрын
🤟
@WhiteSiroi
Жыл бұрын
thank you very much, very helpful
@victoriasingveena441
9 ай бұрын
Cool
@cockroachdb
9 ай бұрын
We couldn't agree more.
@Nodsaibot
Жыл бұрын
oooooooor create a JSON with the cached results :D
Пікірлер: 29