5.3 Introduction to Indexing in DBMS

Подписаться 672 тыс.

Просмотров 414 тыс.

50% 1

📝 Talk to Sanchit Sir: forms.gle/WCAFSzjWHsfH7nrh9
💻 KnowledgeGate Website: www.knowledgegate.in/gate
📲 KnowledgeGate Android App: tiny.cc/KG_Official_App
➡ Do not miss our Bestseller Courses:
🔴 GATE Guidance-2025: www.knowledgegate.in/learn/GA...
🟠 GATE Guidance Plus-2025: www.knowledgegate.in/learn/GA...
➡ Contact Us:
🟩 Whatsapp Chat: wa.me/918595120657
📞Call on: +91-8000121313
🟦 Telegram Updates: t.me/kg_gate
🟩 Whatsapp Updates: www.whatsapp.com/channel/0029...
📧 Email: contact@knowledgegate.in
➡ Our One Shot Semester Exam Videos: 👇
▶ Operating System: • Complete Operating Sys...
▶ DBMS: • Complete DBMS Data Bas...
▶ Computer Network: • Complete CN Computer N...
▶ Digital Electronics: • Complete DE Digital El...
▶ Computer Architecture: • Complete COA Computer ...
▶ Data Structure: • Complete DS Data Struc...
▶ Algorithm: • Complete DAA Design an...
▶ Software Engineering: • Complete Software Engi...
▶ Theory of Computation: • Complete TOC Theory of...
▶ Compiler: • Complete CD Compiler D...
▶ Discrete Maths: • Complete DM Discrete M...
➡ Free Subject-Wise Complete PlayList: 👇
▶️ DBMS: tiny.cc/kg_yt_DBMS
▶️ Operating System: tiny.cc/kg_yt_OS
▶️ TOC|Automata: tiny.cc/kg_yt_toc
▶️ Computer Networks: tiny.cc/kg_yt_CN
▶️ Digital Electronics: tiny.cc/kg_yt_Digital
▶️ Compiler Design: tiny.cc/kg_yt_Compiler
▶️ Computer Architecture: tiny.cc/kg_yt_COA
▶️ Data Structure: tiny.cc/kg_yt_DataStructures
▶️ Algorithms: tiny.cc/kg_yt_Algorithm
▶️ Set, Relation, Function: tiny.cc/kg_yt_Discrete_Relations
▶️ Graph Theory: tiny.cc/kg_yt_graphtheory
▶️ Group Theory: tiny.cc/kg_yt_grouptheory
▶️ Proposition: tiny.cc/kg_yt_prepositions
#knowledgegate #GATE #sanchitjain
*********************************************************

Опубликовано:

1 май 2017

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 247

@KNOWLEDGEGATE_kg 8 месяцев назад

For complete DBMS, check out this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-YRnjGeQbsHQ.html

@ritammallick4332 7 лет назад

The concepts are very crisp and clear. Excellent examples are given, that further helps in clarification. Thanks a lot !!!

@leojohns576 5 лет назад

The quality of explanation is so good that those ones who hardly understands Hindi are able to get a better understanding about the core topics. Thank you sir for this service. It's a great help for every student in the country. May god bless you

@uditgupta6997 7 лет назад

Great explanation. Very helpful. Clear, concise and beautifully summarized.

@nihaltahariya8858 6 лет назад

Sir ,you are doing an awesome job for student like me who are not able to pay the hefty fees of coachings pipelining pe bhi videos baniyega , Thanks in advance

@mini22q11 5 лет назад

hii sanchit sir i m watching all ur videos it is more than awesome Thank you God bless u :)

@RinchiPola 6 лет назад

your efforts are really really appreciated...

@sachingoel7790 6 лет назад

First of all i say thanks to you sir, this video is helpful to me what to write in my theory exam. Easy understandable.

@ckdhakad 6 лет назад

your way of simplifying the things in easy way is awesome

@computerscienceresearchcen1480 5 лет назад

this is the way of teaching, i have seldomly watch this type of way of teaching, sir you are not only great but super great, baatl ki khal nikal dete ho topic ki, keep doing this well job.

@expertfreelancer8491 5 лет назад

may you live long ....! your effort is truly capable for appreciate

@sagarmukherjee6297 7 лет назад

pls make a video on b and b+ tree with insertion deletion and why they r used

@brijpatel237 6 лет назад

ha yaar...

@vanditsharma5305 6 лет назад

Multilist or inverted Vedeo ki li k do

@karangoel16 6 лет назад

Search sartaj Sahni videos , they are uploaded on his profile pages

@abhishekagrawal3618 5 лет назад

plz mail these to mail.knowledge@gmail.com

@abinashkumarray9557 5 лет назад

awesome explainations!!! Your tutorials are just life saver..Thanks alot sir!!!

@Mona19_05 4 года назад

Thanks for the video! easy to learn and very helpful.

@akshayvijayakumar7711 7 лет назад

nice class sir i really appreciate for doing these classes for us

@nayancygupta3850 6 лет назад

Your video helps in learning and understanding topics well. Pls can u upload sone videos on B and B+ trees numerical because they are quite confusing and I don't find them anywhere else.

@rajanburad5143 6 лет назад

Very vividly explained sir :) :) Appreciated!

@archana2716 5 лет назад

Wow.. Very nice explaination.. Even people who don't know what is SQL will also understand it.. 👍👍

@salempurabhijeet 6 лет назад

Wow superb explanation 👍

@Vocabic 6 лет назад

Thank you so much Sir...great explanation

@vivekgaikwad5012 6 лет назад

Very good explanation.Very useful.

@vasundharasingh4421 6 лет назад

sir please upload more videos on the topics of trees ,graphs and sorting in data structures.we really do need them P.S- u r doing a great job.

@sagarmukherjee6297 7 лет назад

sanchit u give the best explanation dude

@anshulthakur3806 5 лет назад

Very helpful ,thanks a lot sir

@manishfender6162 5 лет назад

thank you sirr.. u are very clear with your concepts... love this video once again thanks..

@srushtimate7884 6 лет назад

thanks for the videos will you explain optimal bianry search tree with example

@moomalabubakar2284 6 лет назад

Helpful lecture, Thank you!

@reenathomas7936 5 лет назад

Sir Ur explanations are really good.

@muhammadwasif938 5 лет назад

Sir you are doing a great job. Love and respect from Pakistan :-)

@muskansoni4885 Год назад

Why 75% attendance rule while we are studying from here one day before the exams (⁠@⁠_⁠@)...btw thank you so much sir ♡

@KNOWLEDGEGATE_kg Год назад

Always welcome! All the best for your exam👍 Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

@RahulSharma-zl4gc 7 лет назад

Sir I see your videos on daily basis...they are very helpful for us... can u plz upload videos on b+trees(physical structure) and more on indexing(as to what sort of questions can come in university exams) in dbms

@KNOWLEDGEGATE_kg 7 лет назад

hi rahul thanks for showing your interest, will be uploading more videos soon..

@shivanisinha9226 3 года назад

Thank you sir for making this concept so clear

@6goyal 5 лет назад

Great way to explain..Thanks Sir

@aasawarisahasrabuddhe9327 6 лет назад

I went through many long videos on this topic BT u made it clear in a short time...thanks a lot

@aniketkumarsingh3860 3 года назад

viru sahasrabuddhe ?

@rupalibairwa3830 6 лет назад

Nice sir ..i understand dis topic in very easy way..thnx

@priyankadhurve208 6 лет назад

sir plz make the videos of hashing techniques and b-trees

@shahi_gautam 5 лет назад

Do I need to do indexing on all the column or Will it is fine to do it on the primary key only?

@devanshmesson2777 2 года назад

Crystal Clear explanation! Thank you so much sir!

@KNOWLEDGEGATE_kg 2 года назад

You're most welcome dear, keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents !

@er.amitsandhu2931 7 лет назад

thanks sir ,. you videos are great source of knowledge. in very smooth way

@KNOWLEDGEGATE_kg 7 лет назад

pleasure is entirely mine amit bhai......

@LearnTheSageWay 4 года назад

very beautifully explained sir

@sachinsharma-kw4zd 6 лет назад

very well explained

@shahrukhahmed8864 6 лет назад

Thanks.It was very helpful ...

@sudeshnaC 6 лет назад

Sir I have read somewhere that in case of dense indexing, the index file contains the search key and the pointer pointing to the address corresponding to that search key in the data block. Here you have mentioned that only the base address of the block is there. Then in that case unsorted file will take time for dense indexing also ( and not only for sparse indexing) . Please clear my doubt.

@AbdulWahab-kk1hs 5 лет назад

You're doing a very nice job. Love from Pakistan

@shakibsiddiqui2999 2 года назад

Sir You are my favourite teacher on youtube ..........your teaching style is amazing

@KNOWLEDGEGATE_kg 2 года назад

Thanks a lot dear student, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

@brijpatel237 6 лет назад

keep it up bhai,maja aa gaya samaj ne mai!!!...

@shahabsohail5112 5 лет назад

Very helpful tutorials

@satyaprakashsahoo7772 5 лет назад

Really sir u r the best teacher...

@sakshiraut4944 Год назад

Your explanation is very helpful 👌

@KNOWLEDGEGATE_kg Год назад

Thank you dear❤️Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

@probirmohonto 6 лет назад

got some good information about index.. Thanks..

@g_aya_thri5595 4 года назад

Thnku so much💓....frm kerala

@ALAMENGINEERINGWORK 5 лет назад

Amazing video lecture i like it to study for gate

@gokulbhoi4057 3 года назад

Great elucidation!!

@chrajeshdagur Год назад

Nice Explanation, At first glance of your look and voice like an actor Sandeep Anand from "may i come in madam" 😀

@KNOWLEDGEGATE_kg Год назад

Haha thanks :) Keep supporting & stay connected for more amazing videos & contents👍😊

@shobhitmittal551 4 года назад

Very clearly explained Sir..

@ApexSpeedster 6 лет назад

sir, is index file always sorted even for unsorted data file?

@prashantrai1739 3 года назад

Nice explanation 👌

@dhrubotara1 7 лет назад

basic points are described in simple way. so, difficult topic become easy and interesting .

@KNOWLEDGEGATE_kg 7 лет назад

thanks a lot sona ji....enjoy

@anupkumar-xo3ch 6 лет назад

guruji tussi great ho,

@18ajai 4 года назад

Very good explanation sanchit ji

@saranyaalluri_explore 7 лет назад

Thank you very much sir. Actually tomorrow is my exam. I was actually afraid before 10 min of seeing this video that how to write exam. But now I am much relaxed after looking this video.Thank you once again sir.

@KNOWLEDGEGATE_kg 7 лет назад

thanks a lot saranya, god bless you...

@karangoel16 6 лет назад

I really like the way you taught the phenomenon of the cache and how the small file and big file access is different

@KNOWLEDGEGATE_kg 6 лет назад

Thank you Karan.. Keep following..

@someshmahajan7903 3 года назад

Very nice explanation 🙏👍

@bhoopendrakumar317 7 лет назад

Happy to see you sir. ...

@KNOWLEDGEGATE_kg 7 лет назад

thanks a lot bhoopendra bhai...

@imprakrut 5 лет назад

Are you also watching this one day before the exams?

@joshking9537 5 лет назад

yes

@daipayanhati2347 5 лет назад

Nope ... On the day of exam

@prasuntiwari4291 5 лет назад

Yes in 1.5x speed

@krishna1.097 5 лет назад

Yess

@AI-zw1rz 5 лет назад

@@prasuntiwari4291 dude us 2x speed

@HossainTech 6 лет назад

Love you sir❤❤❤❤

@saicharanchakrala5028 6 лет назад

Sir,Please make videos on transactions

@equality9304 5 лет назад

One of the best vedio

@abdur_rehmankhan6590 7 месяцев назад

Your teaching method is too Good. ❤❤❤❤

@KNOWLEDGEGATE_kg 6 месяцев назад

Thanks a lot dear @abdur❤ Do like, subscribe & share the video, you can also visit our website www.knowledgegate.in for more amazing videos & contents👍😊

@varuntaneja4654 5 лет назад

The video was awesome but there are some doubt uncleared till end of the video 1. What would be the S.K (Search Key) 2. Generally we access the database by filter in the query based on different attribites and this makes S.K non-specific.

@varuky2727 Год назад

Please upload the classes in english, so everyone gets utilized

@akshaybaura 5 лет назад

This is just wow

@kunalgupta116 2 года назад

most satisfactory explanation

@KNOWLEDGEGATE_kg 2 года назад

Thank you so much Kunal.. Keep learning and supporting. Do visit our website www.knowledgegate.in for more courses and contents.

@uppinfo6602 4 года назад

Thank you sir🙏

@NeerajSingh-sc4ie 6 лет назад

sir """B++ Tree """upload plz....!!

@asad_mirza 4 года назад

helpful video

@vatsal429 4 года назад

nice video sir.....

@borntogoal8492 4 года назад

best yar 1000 times better than my uni professor

@priteshghogale8138 6 лет назад

thank you!!!

@komal27877 6 лет назад

Please provide a lecture on ASYMPTOTIC NOTATION

@chiraglosalka6893 6 лет назад

Sir, can you make videos on Computer Network. Will be very helpful.

@abhi1110 3 года назад

I didn't get the thing, index file store some particular attribute and table will have all attributes, when we fire a query against some particular attribute, then in table also, it will search for that attribute only, so why is it fast in index file than actual table?? How other attributes present in the actual table affects searching??