Lec-99: Secondary Index in Database with Example | Multilevel Indexing

0:00 - Introduction
0:52 - Why Secondary Index
4:09 - Secondary Index (Key)
7:26 - Secondary Index (Non Key)

► Database Management System(Complete Playlist):

Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
►Computer Architecture (Complete Playlist):
► Theory of Computation
►Artificial Intelligence:
►Computer Networks (Complete Playlist):
►Operating System:
►Structured Query Language (SQL):
►Discrete Mathematics:
►Compiler Design:
►Number System:
►Cloud Computing & BIG Data:
►Software Engineering:
►Data Structure:
►Graph Theory:
►Programming in C:
►Digital Logic:

---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:

[achintyanathsrivastava]

People say online lectures lead to unresolved doubts, but over here as soon as the doubt arises, your words come in " agar yaha iski jagah yeh hotah " and it clears it all . Thank you for being my 2AM teacher

[yusufahmed]

There is not A SINGLE good video on secondary index except this. Take love from Bangladesh for saving our lives.

[syedyusufali]

have 2hrs left for exam and doing final concepts. You're a savior.

[sravani]

Even I don't know Hindi well, I could understand your lecture..Your way of teaching is amazing 👌🏻. Thanks alot, Sir 🤩

[shreyshreyansh]

i was banging my head on this topic for 3 hours and you made it so simple... you are simply awesome, plz never stop making videos :)

[Shri.simple]

You are just amazing and you cleared me whole concept. Loads of love to you...

[oshniklife]

True ... 1st time I have clear idea about secondary index.. lots of blessings

[kshitijagarwal]

You explanation was so beautiful, almost philosophical! Love your explanations

[__manoj_jaihind__]

You are the best teacher brother, I have passed many of my semesters exams like AI, COA and OS just because of you thanks a lot.

[mujeebrahman]

This has all the details of secondary indexing.. keep up the good work... thanks..

[rupakparui]

I wish if you been in our clg as a teacher but no problem your videos help me a lot to understand the topic as well as to pass the semester.

[digitierraads]

Thank you for making a complex topic simple.

[paragroy]

Thanks for the playlist sir...it is extremely helpful....

[Mehedihasan-rahat]

Little bit of complex but still have reliance on your lecture thank you🎉

[ravipanchal]

No one is better than you man, Hats off to your explanation

[chiragjaiswal]

For the key Secondary Index, I think N in logN+1 will be equal to No of entries in Index Table this will give us the block in which our key is present and +1 for searching in that particular block.
And According to you N=No. of block in Index table so this will give us a particular block and then we will search on this block then why we are doing +1 I think this can be done in also log time complexity bcz the key are sorted in order in index block. So overall Time complexity can be N=No. of block in index table, n=No. of entries in Each block of Index table

[mimanshajyoti]

Very clear content. Thanks for the awesome explanation !!

[surbhibansal]

Excellent video ! You are a great teacher

[sourav]

sirji 3 din se iske upar padh padh ke dimaag kharab ho gya tha, Finally aapke video se samajh me aaya.

[PythonisLove]

great detail covered...I am completely relying on your channel for everything.