Lec-96: Types Of Indexes | Most Important Video on Indexing

Поділитися
Вставка
  • Опубліковано 19 вер 2024
  • 👉Subscribe to our new channel: / @varunainashots
    ► Database Management System(Complete Playlist):
    • DBMS (Database Managem...
    Other subject-wise playlist Links:
    --------------------------------------------------------------------------------------------------------------------------------------
    ►Design and Analysis of algorithms (DAA):
    • Design and Analysis of...
    ►Computer Architecture (Complete Playlist):
    • Computer Organization ...
    ► Theory of Computation
    • TOC(Theory of Computat...
    ►Artificial Intelligence:
    • Artificial Intelligenc...
    ►Computer Networks (Complete Playlist):
    • Computer Networks (Com...
    ►Operating System:
    • Operating System (Comp...
    ►Structured Query Language (SQL):
    • Structured Query Langu...
    ►Discrete Mathematics:
    • Discrete Mathematics
    ►Compiler Design:
    • Compiler Design (Compl...
    ►Number System:
    • Number system
    ►Cloud Computing & BIG Data:
    • Cloud Computing & BIG ...
    ►Software Engineering:
    • Software Engineering
    ►Data Structure:
    • Data Structure
    ►Graph Theory:
    • Graph Theory
    ►Programming in C:
    • C Programming
    ►Digital Logic:
    • Digital Logic (Complet...
    ---------------------------------------------------------------------------------------------------------------------------------------
    Our social media Links:
    ► Subscribe to us on UA-cam: / gatesmashers
    ►Subscribe to our new channel: / @varunainashots
    ► Like our page on Facebook: / gatesmashers
    ► Follow us on Instagram: / gate.smashers
    ► Follow us on Instagram: / varunainashots
    ► Follow us on Telegram: t.me/gatesmash...
    ► Follow us on Threads: www.threads.ne...
    --------------------------------------------------------------------------------------------------------------------------------------
    ►For Any Query, Suggestion or notes contribution:
    Email us at: gatesmashers2018@gmail.com

КОМЕНТАРІ • 119

  • @CombineCSTheExtraStep
    @CombineCSTheExtraStep 4 роки тому +275

    You don't need to say please in your video for subscription...................your way of explanation of concept in itself is motivating for all learners... each & every learner will subscribe automatically

    • @nijwmnarzary7829
      @nijwmnarzary7829 3 роки тому +1

      Thats true...

    • @sourabhdhavale9232
      @sourabhdhavale9232 2 роки тому

      yes sir

    • @AnkitSingh-wq2rk
      @AnkitSingh-wq2rk 2 роки тому +5

      bhai bolte hai apne friends ko batao channel ke baare mein ... mai jise bhi jaanta hun woh sab idhar hi aake dekhte hai lol

    • @tarunnaik3053
      @tarunnaik3053 2 роки тому

      That's true anyway we'll be grateful for him

    • @ravi_pawar_vlog
      @ravi_pawar_vlog Рік тому

      Yes I am also subscribe automatically All topics solutions are very easy

  • @Dineshkumar-wj8so
    @Dineshkumar-wj8so 4 роки тому +37

    I have been working in the software industry from last 3 and half years, I was very confused with indexing, I know how it works but only in theoretical manner but the way you have explained is fabulous and the numerical which you solved is great . Great job man. I recommend this channel to colleges student.

  • @ohidotg
    @ohidotg 4 роки тому +12

    Your videos are so good and amazing. The more i watch, the more i get amazed. You take your time to go through the steps which shows your dedication towards teaching. I have utter respect for you. Thank you. Keep the good work up.

  • @daredevilxrage
    @daredevilxrage Рік тому +22

    This person NEVER fails to amaze us with his flawless explaination. Hats off Sir, you're a savior!

  • @100joys
    @100joys 2 роки тому +17

    Sir, when I subscribed in 2019 I knew your channel will grow exponentially. And it is growing all by your hardwork and dedication towards students. Congratulations. And more power to you.

  • @GeerishaAcharya
    @GeerishaAcharya 5 років тому +5

    Thank u so much sir...ur all video r very useful for my tomorrow's exam...

  • @SAKSHIGUPTA-ob8xl
    @SAKSHIGUPTA-ob8xl 3 роки тому +1

    sir aap bahot jada aacha padhate hai India ko aap jaise hi teachers kii jarurat hai, agar aap jaise teacher hongye toh hum jesso ko kabhi padhai boring nahi lagegii

  • @sajansekhu8785
    @sajansekhu8785 4 роки тому +1

    Thnkk u so much varun sir..u r the star of computer science....nd u r channel is vry hlpful for all cs student.....sir aapko nhi pta aap kitne logo kii bhlayi kr rhe ho..Waheguru always bless u..🙏🙏🙏🙏🙏

  • @trinath6941
    @trinath6941 3 роки тому +1

    i have seen all the videos from the beginning your playlist is the best on the internet, I will suggest all my college friends to watch ur playlist

  • @DevH10
    @DevH10 2 роки тому +3

    so perfect explanation
    thank you man
    you deserve every bit of success you achieve

  • @zaffariqbal3671
    @zaffariqbal3671 5 років тому +13

    Thank you so much sir.......no word to define your quality....i appreciate your work..please upload some more videos on dbms

  • @nitikalakra3490
    @nitikalakra3490 3 роки тому +1

    you are too good. Best teacher I have come across.

  • @dayanandswami8109
    @dayanandswami8109 2 роки тому

    Very nice explanation. I salute you. You are the real teacher who born only for teaching

  • @rohitsengar100
    @rohitsengar100 3 роки тому +1

    thanks!!precise teaching that reduces time to understand the topics

  • @snehamhra
    @snehamhra 4 роки тому +3

    Sirrrr..... Keep You Are Best ❤️ More Power to You

  • @JYOSHNAPOLAVARAPU-rp1xp
    @JYOSHNAPOLAVARAPU-rp1xp 9 місяців тому

    Man what a mind blowing explanation. Thanks for these kind of explanation

  • @henafatma5101
    @henafatma5101 4 роки тому +1

    Jarur hm ye keh sakte hai aap cse ka best teacher hai..

  • @ravineshkumar3738
    @ravineshkumar3738 4 роки тому +6

    Awesome keep it up bro :)

  • @praveenpandeypandey3359
    @praveenpandeypandey3359 Рік тому +21

    Please don't say please..

  • @tarunnaik3053
    @tarunnaik3053 2 роки тому

    You're lectures are a great way to gain knowledge

  • @nailsmarble7654
    @nailsmarble7654 9 місяців тому +1

    Sir ap itne pyar se bolte ho like aur subscribe ka, ki humara hath vese hi like aur subscribe ki button par chala jata hai...😅

  • @U2011-n7w
    @U2011-n7w 2 місяці тому +1

    Best video

  • @sheelas3593
    @sheelas3593 7 місяців тому

    Sir. your explanation is very good. it is easily understandable

  • @RS-hi6cz
    @RS-hi6cz 4 роки тому

    you are really great with clear communication skill

  • @KumarAnalytic
    @KumarAnalytic 4 роки тому

    *Thanks Varun, super trick to understand indexing👍👍*

  • @prakashmandekar4948
    @prakashmandekar4948 5 років тому +1

    hello sir ,
    your lectures are very helpful.
    i have learned your DBMS lecture ,the way you teach from scratch is the very important thing.
    sir can u please make a full course lectures on TOC .
    thank you sir.

  • @prasenjitsaha5322
    @prasenjitsaha5322 5 років тому +2

    Thank you so much. Please make videos on insertion and deletion in btree and b+ tree.

  • @gameguru112
    @gameguru112 2 роки тому +1

    You are a good teacher dear sir ☺️

  • @niteshsingh7157
    @niteshsingh7157 3 роки тому +1

    No need to say please sir your contain is awesome we like it very much.... I Subscribed your channel sir

  • @sreelakshmisaji4815
    @sreelakshmisaji4815 3 роки тому +1

    I don't know hindi well. But I'm able to understand the concept very well. Thank you sir for your effort.

  • @jaswanthm7739
    @jaswanthm7739 2 роки тому +1

    ur always superb no need to mention please thank you very much

  • @Aditya95111
    @Aditya95111 4 роки тому

    Awesome , you are great sir 👌👌🙏🙏🇮🇳🇮🇳

  • @rashmibn3630
    @rashmibn3630 2 роки тому

    Well explained .....great teacher..

  • @aksharaverma6452
    @aksharaverma6452 3 роки тому

    you’re the best sir!! whichever subject it is,, u make the concepts so clear and understandable!! Please keep doing this. Thankyou so much!❤️

  • @Pranav-pl7eg
    @Pranav-pl7eg 2 роки тому

    Wow!!! what a explanation

  • @saptarshichattopadhyay8234
    @saptarshichattopadhyay8234 3 місяці тому

    Thank you so much sir 🙏 ☺️

  • @pakhisingh1470
    @pakhisingh1470 3 роки тому

    Thanku so much sir..... Ur playlist is best🥰

  • @zeetech6829
    @zeetech6829 4 роки тому

    Bhaia g no words to say, at the end love your concepts you made my exams

  • @vivekmittal2043
    @vivekmittal2043 3 роки тому +1

    Awesome lecture series, very helpful for college exams. Thank you.

  • @viral_video_ayana
    @viral_video_ayana 3 роки тому +1

    Thankyou sir

  • @VisibleVJ
    @VisibleVJ 2 роки тому

    Explained in seconds great explanation sir😌

  • @clanguage1985
    @clanguage1985 4 роки тому

    Ur videos just amazing 👍bhai

  • @stephenraj6011
    @stephenraj6011 Рік тому

    Thank you

  • @anishchar4282
    @anishchar4282 2 роки тому

    Thank you very much sir 🙏🏻

  • @shlokhinge6122
    @shlokhinge6122 2 роки тому

    Thankyou sir for such a amazing content :)

  • @kittensworld8869
    @kittensworld8869 7 місяців тому

    Thank you sir very helpful

  • @ajitpawar10
    @ajitpawar10 2 роки тому

    thanks

  • @mdaniquzzaman8120
    @mdaniquzzaman8120 Рік тому

    MASHALLAH sir very helpful ❤

  • @sushmarose1703
    @sushmarose1703 2 роки тому +1

    Hello Sir, Thank you so much for the sharing the knowledge you have with whole hearted.
    I have one doubt here. What are non-clustered index. Is it same as Secondary index. Please explain Sir.

  • @upparipooja8936
    @upparipooja8936 2 роки тому +1

    Simple and fast

  • @ΕυτύχηςΚωνσταντουδάκης

    good way of Teaching

  • @PremGupta-u3r
    @PremGupta-u3r 5 місяців тому

    Good sir

  • @YasImtiaz
    @YasImtiaz 5 років тому +1

    Nyc work bro !

  • @Mehedihasan-rahat
    @Mehedihasan-rahat 11 місяців тому

    Your channel requires more than subscription ..❤❤

  • @prashantproduction7335
    @prashantproduction7335 5 років тому

    Tmr my DBMS exam... Thanks for clear my concept

  • @bulbulsarker3162
    @bulbulsarker3162 Рік тому

    Very good tutorial

  • @partikmishra9063
    @partikmishra9063 4 роки тому

    Your vedio is osm sir 😊😊

  • @1omarkashif
    @1omarkashif Рік тому

    good video sir thank you

  • @devendrakanojiya
    @devendrakanojiya Рік тому +1

    Sir I appreciate your work but maybe be due to empty room , kamre Mai echo create ho raha hai aur audio quality achi nahi aa rahi , hope you will do something for that , btw thanks 🙏🙏👍👍

  • @ashutoshsingh1621
    @ashutoshsingh1621 Рік тому

    Thank you sir

  • @Vinay49360
    @Vinay49360 4 роки тому

    Bhai, you are the best. Love you❤

  • @animationcrust1993
    @animationcrust1993 3 роки тому

    Easy explained

  • @prasannapm3220
    @prasannapm3220 2 роки тому

    thank you sir!!

  • @syedazharmohiuddin3007
    @syedazharmohiuddin3007 Рік тому

    sir i wished ki app cosm subject ka upar video lectures bana sakha

  • @abhishekdas4023
    @abhishekdas4023 4 роки тому +1

    plz give lecture on concerncy control...

  • @naineshvala5906
    @naineshvala5906 4 роки тому

    Physical ordering is same as logical ordering with uniqueness then its primary index

  • @shruthishreemk
    @shruthishreemk 5 років тому

    Sir ur videos are awesome dan worst paid courses.. doing a very good job.. pls cover atleast useful topic before NTA/UGC NET

  • @csspms7970
    @csspms7970 3 роки тому

    great video

  • @Preeti-lifestyle
    @Preeti-lifestyle 5 років тому

    Superb sir

  • @jinkhatri5223
    @jinkhatri5223 3 роки тому +1

    method is good to understand well
    im preparing for IT officer
    so pls make Banking and insurance IT officer centric videos

  • @punjabsindh6854
    @punjabsindh6854 3 роки тому

    great sir g

  • @aditirawat6128
    @aditirawat6128 Рік тому

    Thank youuuuu

  • @yashgajewar9019
    @yashgajewar9019 3 роки тому

    Best 💯👏

  • @samiyakhan3049
    @samiyakhan3049 Рік тому

    Nice 👍👍

  • @pawansmy1844
    @pawansmy1844 5 років тому +9

    you no need to request for likes and share ....☺☺☺☺☺

  • @ishwarshelke128
    @ishwarshelke128 2 роки тому +2

    1M strong

  • @Preeti-lifestyle
    @Preeti-lifestyle 5 років тому

    Plz data structure per bhi videos bnaye

  • @AbdulMajeed-lx6ky
    @AbdulMajeed-lx6ky Місяць тому

    Sir kya ya topic (index) DSA mn b same ha

  • @riturajsharma3937
    @riturajsharma3937 8 місяців тому

    I am watching this video before 2 hours from my exam or ek daam mst smj aagye 😂😂😂

  • @arvindraj8877
    @arvindraj8877 Рік тому

    love u bhai

  • @sumitjaiswar4358
    @sumitjaiswar4358 2 роки тому

    Is Unique index and primary index is same???

  • @ksriram1997
    @ksriram1997 Рік тому

    🙏

  • @decostarkumar2562
    @decostarkumar2562 2 роки тому

    In sparse index after reaching a block we need to search in that block . So how that searching is 1? 🤔

  • @rajeshbadariya4823
    @rajeshbadariya4823 5 років тому +2

    sir is video ko DBMS ki playlist me add kro

    • @GateSmashers
      @GateSmashers  5 років тому

      Sure ...Thank you for your Suggestion 😊👍

  • @shravaneelokhande2211
    @shravaneelokhande2211 11 місяців тому

    Sir link open nahi ho Rahi hai notes ke

  • @mkay7800
    @mkay7800 3 роки тому

    best

  • @arnobchak
    @arnobchak Рік тому

    Sir aap definition blackboard mae likhiye

  • @prashmai6368
    @prashmai6368 4 роки тому

    sir system design ka lecture dejiye.

  • @zzzz-no4vd
    @zzzz-no4vd 4 роки тому

    Primar clustered secondary

  • @PradeepSingh-rt7pm
    @PradeepSingh-rt7pm 4 роки тому

    Sir multi level indexing???

  • @Sahil_Antil
    @Sahil_Antil 3 роки тому

    Can non key be null?

  • @pranshuaggarwal2788
    @pranshuaggarwal2788 2 роки тому

    Ek type batana bhul gye sir aap. Already Software Engineer ho, but DB Indexing na aati ho, woh bhi isse dekhen.

  • @codediary2568
    @codediary2568 2 роки тому

    reached till 90

  • @AyushKumar-cj6dz
    @AyushKumar-cj6dz 2 роки тому

    one day before sem exam only gate smasher is enough

  • @AugustineBiswas
    @AugustineBiswas Рік тому

    love u

  • @wahidkhan9390
    @wahidkhan9390 3 місяці тому

    Bhai tum na aapna advertisement kaam kr…. 4 min ka video me 5 min ka ads aate hai🫡

  • @asurya3348
    @asurya3348 4 роки тому

    I can't understand your language sir please try to teach in English it would be very helpful to other students from other languages

  • @hallo-xp2wh
    @hallo-xp2wh 3 роки тому +1

    am i the only one who clicked thinking it is indexing operations in production-ME/PI

  • @RahulSharma-qn9gi
    @RahulSharma-qn9gi 2 роки тому +1

    speed 1.5 x
    🙂

  • @gouravnishad6829
    @gouravnishad6829 3 роки тому

    Sir, man toh karta hai apni IIT ki tution fee aapko de doon... Unke lectures toh dekhta hi nhi mai xD

    • @GateSmashers
      @GateSmashers  3 роки тому

      hahaha..bheju upi 😉 anyways thank you for your appreciation