Lecture 14: Why Indexing is important in Database Systems || DBMS Interview question

This Video will make your understand the idea behind "Why Indexing is important in Database Systems"

There is a lot to learn, Keep in mind “ Mnn bhot karega k chor yrr apne se nahi hoga ya maza nahi aara, Just ask 1 question “ Why I started ? “

Do provide you feedback in the comments, we are going to make it best collectively.

Connect with Lakshay:

Connect with me here:

Telegram Group Link: Love Babbar CODE HELP

TimeStamps:
00:00 - Why Indexing is used?
15:30 - Primary Index / Clustering Index
18:30 - Dense Index VS Sparse Index
34:33 - Multi-level Index
39:00 - Secondary Index

Intro Sequence: We have bought all the required Licenses of the Audio, Video & Animation used.

#DBMSBusted #LoveBabbar #Lakshay

[cheems]

We cannot apply binary search directly in actual disk records because records are not necessarily stored in a contiguous manner in the disk, we use B tree (threaded M way tree) for this. It makes insertion and deletion faster as well.

[ritikabhatt]

Please complete this course sooon . Thankyou for the efforts. This course these types of explanations are worth it ❤️

[prashanthule]

Most underrated course on SQL and DBMS, , , appreciate the effort 👏👏
Can you make a video after this course regarding in which different profiles we can get a job in SQL and DBMS.

[RashmitaDebnath_]

This course is very much helpful, please complete it as soon as possible as placements are on its ways.

[anshumaan]

@10:55, Bhaiya for student with roll no. 843,
the block will be Block-85, not Block-843 🙂

[ayushuniyal]

placements have started .please tell when will this series be completed ??please complete this series as soon as possible.

[khushalsagarkumawat]

Bhaiya mai SQL k jitne bhi interview questions dekh rha hu unn sbme triggers naam k ek topic ka question jrur h.
Aap kb krwaoge wo topic kyunki maine abho saare notes download krke dekhe unme se ek me bhi triggers naam ka topic nhi tha.
Baaki ye series bahot sahi jaa rhi h. MySQL ki 4 ghante wali video ne confidence de diya CV k skills section me MySQL likhne ka

[flamekaiser]

Thanks for this video, please add more Videos Looking Forward to it....

[justlc]

Thanks for all your efforts!!
When are the next videos going to be released? Eagerly awaiting!

[TheHonouredOne-SatoruGojo]

Bhaiya your teaching skills are awesome. Thank you very much for this video.

[xclusionmedia]

I know you are doing your best.. but please complete the series fast, placements have started

[syedalamsiddiqui]

"Bahot hi badhiya" remains constant. Mazaa aa gya bhai OS me bhi aur ab DBMS me bhi...

[vikashhhchoudhary]

i don't know why people are saying this is the best explanation, he is also confused in this video

[rohitkumarmeena]

God level content literally god level, genius guys next level next level ....

[yashasvic]

A thumbs up 👍 for your efforts and teaching skills, precise notes brother.

[vikrantd]

Please Complete this course Bhaiyya. DBMS Ache se flow main karna hai waiting for next lecture

[vaibhavagarwal]

shouldn't the student with id = 841 be at B85 and not at B841? timestamp: 10:55

[beinghappy]

Thanks for the amazing video on indexing.

[sanyamagarwal]

lakshya sir abhi kitni or videos hai or kab tak complete hojayegi ? kyunki placements chal rhe hai...

[muskan_vlogger]

1.Primary indexing simply meaning using primary key as a search key
2.Secondary indexing simply means using non prime key as a searching key
3.Clustering indexing is based on non primary key and of used when records are grouped

Hope i am correct …
Little bit i am getting confused by this lecture 😅