• Counselling Guruji is our latest product & a well-structured program that answers all your queries related to Career/GATE/NET/PSU’s/Private Sector etc.
You can register for the program at: https://goo.gl/forms/ZmLB2XwoCIKppDh92
You can check out the brochure at: https://www.google.com/url?q=http://www.knowledgegate.in/guruji/counselling_guruji_brochure.pdf&sa=D&ust=1553069285684000&usg=AFQjCNFaTk4Pnid0XYyZoDTlAtDPUGcxNA
• Link for the complete playlist of DBMS is:
• Links for the books that we recommend for DBMS are:
1.Database System Concepts (Writer: Avi Silberschatz · Henry F.Korth · S. Sudarshan) (Publisher: McGraw Hill Education)
2.Fundamentals of database systems (Writer:Ramez Elmsari,Shamkant B.Navathe)
3.Database Management Systems (Writer: Raghu Ramkrishnan, JohannesGehrke)
4.Introduction to Database Management (Writer: Mark L. Gillenson, Paulraj Ponniah, Alex Kriegel, Boris M. Trukhnov, Allen G. Taylor, and Gavin Powell with Frank Miller.(Publisher: Wiley Pathways)
• Check out our website http://www.knowledgegate.in/
• Please spare some time and fill this form so that we can know about you and what you think about us:
• Your review/recommendation and some words can help validating our quality of content and work
so Please do the following: -
1) Give us a 5-star review with comment on Google
2) Follow our Facebook page and give us a 5-star review with comments
3) Follow us on Instagram
4) Follow us on Quora
• Links for Hindi playlists of other Subjects are:
Digital Electronics: https://www.youtube.com/playlist?list=PLmXKhU9FNesSfX1PVt4VGm-wbIKfemUWK
Graph Theory: https://www.youtube.com/playlist?list=PLmXKhU9FNesS7GpOddHDX3ZCl86_cwcIn
Group Theory: https://www.youtube.com/playlist?list=PLmXKhU9FNesQrSgLxm6zx3XxH_M_8n3LA
Set Theory: https://www.youtube.com/playlist?list=PLmXKhU9FNesTSqP8hWDncxpCj8a4uzmu7
Data Structure: https://www.youtube.com/playlist?list=PLmXKhU9FNesRRy20Hjr2GuQ7Y6wevfsc5
Computer Networks: https://www.youtube.com/playlist?list=PLmXKhU9FNesSjFbXSZGF8JF_4LVwwofCd
• About this video:
This video discusses the Types of Indexing in database in Hindi. Important topic of database Indexing like need of indexing in database management indexing, Why we do indexing in files in database, How we do indexing in dbms, Types of indexing, Methods of Indexing, Advantages of Indexing, How to access a file fast in database, Single level Indexing in database file, Multilevel indexing in database file structure in dbms, Primary Indexing in database, Clustered Indexing in database, Secondary Indexing file in dbms, Advantages of using single level Indexing in database are discussed.
Single level index: This means we create index file for the main file, and then stop the process.
Multiple level index: This means, we further index the index file and keep repeating the process until we get one block. Multi-level Index helps in breaking down the index into several smaller indices in order to make the outermost level so small that it can be saved in a single disk block-0, which can easily be accommodated anywhere in the main memory.
A.) PRIMARY INDEXING-
i)Main file is always sorted according to primary key.
ii)Indexing is done on Primary Key, therefor called as primary indexing
B.) CLUSTERED INDEXING: -
i)Main file will be ordered on some non-key attributes
ii)No of entries in the index file = no of unique values of the attribute on which indexing is done.
iii)It is the example of Sparse as well as dense indexing
C.) SECONDARY INDEXING-
i)Most common scenarios, Suppose that we already have a primary indexing on primary key, but there are frequent query on some other attributes , so we may decide to have one more index file with some other attribute.
ii)Main file is ordered according to the attribute on which indexing is done(unordered).
iii)Secondary indexing can be done on key or non-key attribute.
iii)It is an example of dense indexing.
Indexing in dbms, Indexing in dbms tutorial in hindi,about indexing in dbms,indexing and hashing in dbms, terminologies in indexing in database,indexing in dbms example,indexing in dbms tutorial,disadvantages of indexing in dbms,indexing in dbms for gate,