Bhai, ye to real treasure mil gaya. Thank you RUclips for suggesting this channel. Excellent presentation bhai, better than other free and paid courses.
Thank you for the encouraging words. I would greatly appreciate it if you could spread the word about the channel. I am working hard to consistently complete all the playlists on the channel. Your support means a lot.
Keep on making videos Brother. I can see the subscribers are quite less than what actual should be but with your consistency, you will soon have millions of followers. What an easy language and examples to explain.
Your clear and concise explanations combined with your engaging voice made this topic incredibly easy to grasp. I learned so much even about aspects I didn't previously know I was interested in. Thank you for sharing your knowledge also " babhut badhiya koi dikkt nahi "
Indexing works best when cardinality is maximum. It doesn't work best for all data types when there is a large number of tuples in the table eg datetime. Also write becomes heavy when multiple indexes is applied
@engineering Digest....my question is [ 1,4,2,9,0] ispe maine indexing ki nd where clause me kaha 9 dhund k lao...toh vo last element hoga...so ultimately puri list hi iterate karni padi na...so indexing ka faayda kya hua is case me...kya aur koi technique hai?
puri list iterate nahi krega. It will do binary search which has logN complexity. Bole toh pehele middle element check krega agar wo desired no. is chhota hua toh middle and last k bich ka element check krega.... and so on.
Bhai, ye to real treasure mil gaya.
Thank you RUclips for suggesting this channel.
Excellent presentation bhai, better than other free and paid courses.
Thanks and welcome 🙏
Thank you for the encouraging words. I would greatly appreciate it if you could spread the word about the channel. I am working hard to consistently complete all the playlists on the channel. Your support means a lot.
Finally I got the idea behind Indexing. Thank you
samjhane ka tarika bada casual tha sir maja agaya 2 saal purana content is far better then other paid courses.
Keep on making videos Brother. I can see the subscribers are quite less than what actual should be but with your consistency, you will soon have millions of followers. What an easy language and examples to explain.
best ever explanation of understanding and using indexing.. thanks alot brother
Thanks b rather for uploading genuine contents and this channel provide only. Valuable no bakwas ❤❤
Thankyou for time saving , gabaar khush hua 😅
One of the best videos on this topic. Thanks for posting sir.
One of the best videos on this topic💥
One of the best explanation, I've found on the internet.
superb 👍
Wow, thanks!
Mast gyan diya last m, maza agaya❤❤
PERFECT BRO ... so easy to understand .... thank yoy
One of the great lecture I watched today on this topic❤❤🎉
U make the concept so easy to understand.
Thanks, deep and nicely explained.
Interviewer will not satisfy with single statement ans, this much is required to crack interview.
Thanks bhai !!!
Your clear and concise explanations combined with your engaging voice made this topic incredibly easy to grasp.
I learned so much even about aspects I didn't previously know I was interested in. Thank you for sharing your knowledge also " babhut badhiya koi dikkt nahi "
This whole series can be really useful for answering concept base questions in interview.
Explanation is next level !!!
Kal ka interview maze se niklega
Very well explanation in such a sort duration of time. Thank you for making this video.
The explaination is top notch
Thanks! Finally got the idea of behind the scenes was scratching my head off until found this !!
Good course for beginner. Nicely explained.
Wow bohot sahi explanation
Great explanation, finally I can explain in interview about indexing. Thanks 😇
Thank you. Could you please share the playlist on your LinkedIn? It would be a huge help.
this was precise yet informative, thanks!
amazing ..simple explanation..easy to understad...
subscribed
nice sir aaj samjh aa gya h good sir ji
Well explained bhaiyya
to the point.. great and thank you...
BRAVO !! to the point xplanation
Very good Explanation Sir...❤️
Up till an extent it works best. But after that we need to implement partitioning
Behtareen ❤
Mtlb Ghanshyam ek majdoor hai aur Shyam ek digital majdoor from Infosys
plz make complete Sql playlist sir
Indexing works best when cardinality is maximum. It doesn't work best for all data types when there is a large number of tuples in the table eg datetime. Also write becomes heavy when multiple indexes is applied
Great explanation,thanks a ton .
where is full playlist link
nice explanation
v.nice video kafi helpful rahi mera liya
thanks bhaiyaa ache se smjh aagya
To the point explanation love it
Thank you. Don't forget to join our discord.
Thank you so much sir for your superb explanation. Maza Aya👏
Most welcome
just wao..👏
such a small precisive video... wow
Hi, your video is quite good and easily understandable.. Can uh pls make video of consistent hashing too.
I will try my best
Thank you ❤sir 🙏 😊
agar database m kuch b doubt h , then ek hi solution Engineering Digest
brilliant explanation bro
Thank you 🙂
Sab samajh aa gaya
Thank you brother
awesome!!!
Awesome
what if we have write intensive use of data, what should we use
I got the same interview question in Data Engineering
You are just awesome brother. The way you explain its just amazing. Thank You 💯
well explained
sir batch processing ki video le aaiye na badiya se dynamic file upload
thanks
Perfect
@engineering Digest....my question is [ 1,4,2,9,0] ispe maine indexing ki nd where clause me kaha 9 dhund k lao...toh vo last element hoga...so ultimately puri list hi iterate karni padi na...so indexing ka faayda kya hua is case me...kya aur koi technique hai?
puri list iterate nahi krega. It will do binary search which has logN complexity. Bole toh pehele middle element check krega agar wo desired no. is chhota hua toh middle and last k bich ka element check krega.... and so on.
@@aviiiiiiiiiiiiiiiiiiii thanks bhai ab samja❤
Nice video
does it actually sort the col values?
great
B+ trees is used in indexing right, not the B trees.
Sir, Is pointer to row similar to the foreign key?
No, pointer stores the address to each row and a foreign key is a column in one table that refers to the primary key of another table
@@EngineeringDigest Okay, Understood Sir.😊
💫💫🔥
Bestttttttttttttttttttttttttttttttttttttttttttttttt videooooooooooooo 🥹!
Notes bhi upload kar do
you cannot find this content even on paid course
like ❤ swikar kijiye guru ji
😮😮😮
🥲🥲👍🏻👍🏻👍🏻👍🏻