5.4 Types of Indexing in DBMS | Primary | Clustered | Secondary | Sparse | Dense

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

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

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
*********************************************************

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

2 май 2017

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@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

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

Primary indexing - Database is sorted.We use primary key for indexing. clustered indexing - DB is sorted but we use non prime attribute for indexing. Secondary indexing - DB is NOT SORTED and we can use any of primary or non primary attribute for indexing. Sparse indexing - Every record in database is entered in index table. Dense indexing - Every value(attribute that we have considered for indexing) has been entered in index table.

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

short summary huh. Nice. Once after watching looking at this means something.

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

tnks

@2mat012 15 дней назад

sparse ka not entered hoga

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

Just came here to say Thank You to u sir!!! 4years ago in my 2nd year, I referred ur videos and passed...and currently working in an MNC❤️

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

Glad to know that Amar.. Many congratulations.. Stay blessed, stay connected !!

@SHRIANSHPANDEY 6 лет назад

if a teacher like you will be there in engineering clgs then I swear every student will get very good marks ..... I swear seriously a great teacher you are , thanks a ton sir

@papanchowdhury7881 7 лет назад

sir plzz upload B tree ,B+tree videos.........

@ujjwaljain2196 7 лет назад

Why in the conclusion at 8:34 you say that sparse means "when each record has got an entry in the index file"? Isn't it when each record DOESN'T get entry in the index file?

@guyguy7642 5 лет назад

Yes, you are correct. I guess he said that by mistake!

@John12685 5 лет назад

same confusion here bro

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

yeah! I also feel the same

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

Lets say we have a table with M records . In those M records we have N different values of the attribute we are applying indexing on, such that N

@AbhishekYadav-tk5bj 2 года назад

Same confusion

@profajaysharma 6 лет назад

Very nice discussion. I was always missing this topic due to lack of information. But now i got it with more clarity. Thanks. Can you please upload video on decidability and undecidability and closure or language.

@nidhirajeev1398 6 лет назад

No Words... Even though i dont know hindi well, now i'm understanding what actually this is!

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

The effort you are putting into your videos is absolutely precious. God bless you.

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

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

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

One question sir, Why you consider sparse and dense both in example 2 at 7:27? The sparse index works on Primary attributes and here value repeats ?

@atharuddin7935 5 лет назад

Thankyou for giving such a clear explanation sir.

@jassikaur6180 7 лет назад

sir plZ upload lecture s on b ,b+ trees .

@santoshrauniyar5286 6 лет назад

wow.................sir you are best better superb.... for cse student love you sir .............

@ammoj8164 7 лет назад

sir your lecture was really helpfull.. thanks sir..

@DeepakKumar-ob6yx 6 лет назад

sir make more videos.... more student will watch because it is now exam months

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

Hello, Sanchit. You said during 2:27 that Primary index and clustering index are different on. But they are same on they basis of Primary key, I think as below. A clustering index is an index whose search key also defines the sequential order of the file. *Clustering indices are also called primary indices. Please clarify this ambiguity.

@aaps296 5 лет назад

Sir confused with the definition of sparse indexing, as per my knowledge in sparse indexing "index records are not created for every search key" or "The index record appears only for a few items in the data file".

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

thanks for the diff bw sparse and dense indexing:) , but .... 02:07 "..main file is sorted..", sorted according to what ..primary key ? non key ..?

@Markcarleous1903 5 лет назад

Sir is it different from sql server index types Cluster and non-clustered?

@manishavishwakarma5363 6 лет назад

Very nice and deep explanation.

@debroy8648 7 лет назад

Although it may appear that Primary key is always used in Primary Indexing, but that is not the case. In fact, Primary indexing can be done on ANY search key. as long as the structure is primary, that is the order of the index file and record file are the same. Also clustering indices are a type of primary indexing technique. Correct me if I am wrong.

@dontusehername 6 лет назад

Primary indexing can be done on any candidate key. Only prerequisite is that the DB table is sorted on the key on which you are indexing.

@reenagarg7996 6 лет назад

sir in the case of dense indexing we are storing every value and if we have to search any value then 1st we will see index table so for that also we have to search in index table for the value which we want to search then we will refer main table .so is it the same if we will directly refer main table in that case.how the time will save in that case...m confusing....plzz clear it.

@anshulsatish 6 лет назад

Sir, I was studying indexing with the help of your video lectures but, multilevel indexing lectures are missing. Sir by when you are planning to upload video lecture/s for that topic?

@shano3089 5 лет назад

bhoot zaberdast brother the example you used, fan from PAKISTAN

@jassikaur6180 7 лет назад

thanks for previous lectures

@mohammadhayat2286 7 лет назад

sir will you please explain steps of query processing

@prasuntiwari4291 5 лет назад

Watching one day before exam in 1.5x speed😎

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

2.5x here

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

that's a rookie number

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

Same here bro😇

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

Sir, what do you do when you have multiple same value, say for 5 "a". Now how do you do dense indexing?

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

Oh .....nice sir ... Ur teaching..&thanks sir.....clear concepts

@reenagarg7996 6 лет назад

sir ,videos on ur channel are also not ordered...they are in random order.plzzz provide them orderly.It will helps a lot bcz now we find difficulties in finding the order.Thanks!!

@reenagarg7996 6 лет назад

sir can u share notes on different topics if u have. It will be really helpful if u can.

@RiteshSingh-op3jd 6 лет назад

Thanks a lot sir, helped a lot. :D

@AnilKumaraksuhana 5 лет назад

Dear Sir, I didn't find the multilevel indexing video with b+ tree concept..Kindly provide the link if uploaded...

@sagarmukherjee6297 7 лет назад

pls make a video on what is b and b+, there differences and operations like insertion-deletions great work dude....u r the most humble person

@KNOWLEDGEGATE_kg 7 лет назад

Hi Sagar We will upload lectures on B and B+ tree soon.

@sagarmukherjee6297 7 лет назад

thanks a lot and yeah also on transactions

@rubysing9263 6 лет назад

sir index file in case of dense indexing choti kese hogi as compared to main file jubki apne ka ki sare records enter hoge usme

@aby121 Год назад

this channel is a treasure thank you soo much sir for your efforts

@KNOWLEDGEGATE_kg Год назад

Glad to know this & thanks a lot for your valuable feedback dear @Abdullah❤ Keep learning & stay tuned for more amazing videos & contents 👍

@aby121 Год назад

@@KNOWLEDGEGATE_kg Thank you for sending motivation, I would love to see all your videos because they are just simply amazing. God Bless you ❤❤

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

what is the meaning of sorted main file? on what parameter it has to be sorted?

@avrrajesh 5 лет назад

Very good explanation

@AhamedKabeer-wn1jb 4 года назад

Good explanation..

@sandeepmalviya100 7 лет назад

Very well explained ...

@KNOWLEDGEGATE_kg 7 лет назад

thanks a lot sandeep

@priteshghogale8138 6 лет назад

thank you sir!!!

@ritikajain3818 6 лет назад

Upload a video for Bitmap indices

@narendraparmar1631 6 лет назад

thanks sir ji😃

@shahabsohail5112 5 лет назад

very helpful video

@MohitKumar-tn5mf 6 лет назад

u r the best....

@dishantsharma3227 6 лет назад

Sir have u uploaded the b tree videos?

@Shriyasmom 7 лет назад

Sir ,Your every word is so valuable to me but language problem so plz upload in english soon if possible

@nilofershoaibkhan3253 6 лет назад

plz upload b tree and b+ tree video

@pankajkumarmakwana3527 7 лет назад

Sir, please be my savior. Upload video on B+ tree, we have exams tomorrow.

@KNOWLEDGEGATE_kg 7 лет назад

that will not be possible in such a short notice...

@puru7190 5 лет назад

Sir, isn't clustered indexing based on primary key? Reference: dev.mysql.com/doc/refman/5.7/en/innodb-index-types.html You are claiming that clustered index is based on non key column - this is incorrect as per the official mysql doc.

@santoshvelip8732 6 лет назад

sir can you explan post codinate and pre codinate indexing

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

very useful

@shrishilya_sutar 6 лет назад

Thank you sir

@nikhilparate1631 6 лет назад

u said last sentence - "har record ko entry ni di isliye ye sparx index" then u said each value entry means dense and "each record entry means sparx. " you make confused.

@positivetech 5 лет назад

The instructor is stating some wrong key concepts. It is true that Primary index is defined on an ordered data file and The data file is ordered on a key field. But The key field is generally the primary key [IMP: It's not necessary , it can be any other field] of the relation.

@NishaSharma-nd1dk 3 года назад

Thanks sir g

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

I think there is one more type, i.e, non-cluster indexing.

@NitishRaj 5 лет назад

primary indexing is not necessarily for indexing done on primary key. Correct it

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

helpful

@gowthammalempati8538 6 лет назад

sir plz upload B+ tree

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

🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg 🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg

@harshalbadwaik3372 5 лет назад

Mr. Sanchit Jain Sir its request from all students you don't cover all topics of DBMS like B tree, B+ tree, etc please make a video of all topics so we can watch your videos instead of being watching another video.

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

Hindi mein samjhne ka maja hi alag h

@shakibabsar9698 Год назад

Couldn't find B/B+ tree videos sir .. :(

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

Jab index table se search hi karana hai to hash-table kyun na bnae uski. Binary search hi lagana hai, to index banaya hi kyun

@Shriyasmom 7 лет назад

Sir plz upload in english soon .......

@goyalluckhnawi 7 лет назад

Sir, please upload video on B+ trees, Tomorrow we have exam

@KNOWLEDGEGATE_kg 7 лет назад

hey bro, tomorrow its difficult...bur can upload in 2-3 days..

@shubhamsrivastava5206 6 лет назад

What is bitmap indexes

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

I accept what @ujjwal is saying .. by mistake he said but it he wanted to say that when not every records get the entry in index file for parse indexing

@GauravPandey-ew8cc 4 года назад

Dens me hr record ko nahe balki hr value ko entry milte hai

@PAWANKUMAR-qo9co 6 лет назад

Sir hasing ka video upload karo n please jaldi

@rubysing9263 6 лет назад

sparse me har record ko kaha milti he entry apne last me sparse meto hum randomly lete he

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

summary starts @4:01

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

Sir can u plz upload video on b+trees by 6th(as to what sort of question come in university exams).....(exam on 7th) and can u plz provide ur email id ,I have some doubts

@KNOWLEDGEGATE_kg 7 лет назад

sharma ji kosish puri karenge...

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

okay mail id??