63. Types of Index - Primary Index, Clustering Index & Secondary Index (Over Key & Non Key Field)

Опубликовано: 01 Январь 1970
на канале: CRACK GATE CSE

2,058

Learn about types of index in database, Index are divided into 4 types on the basis of Field & Keys and are as:
1) Primary Index: Search Key (Ordered + Primary/Attribute Key)
2) Clustering Index: Search Key (Ordered + Not Primary/Attribute Key)
3) Secondary Index Over Key: Search Key (Unordered + Primary/Attribute Key)
4) Secondary Index Over Non Key: Search Key(Unordered + Not Primary/Attribute Key)
Watch the video to learn about the types of index.

Learn more about File Organization & Indexing by watching the following Videos:
58. Basics of File Organisation:    • 58. File Organization & Indexing | Fi...
59. Spanned & Unspanned organization:    • 59. Spanned & Unspanned Organization,...
60. Indexing Basics | What is Indexing?:    • 60. Indexing Basics | What is Indexin...
61. Categories of Indexing | Dense Index & Sparse Index:    • 61. Categories of Indexing | Dense In...
62. Most important question on Indexing:    • 62. Most Important Question on Indexi...

Learn Database for GATE, NET, PSU, & NIELIT:    • Database for GATE, NET & PSU (complet...

Learn Linear Algebra for GATE, NET, PSU, & NIELIT:    • Linear Algebra for GATE/PSU/NET (Easy...

Learn Algorithm for GATE, NET, PSU, & NIELIT:    • Algorithm for GATE, NET & PSU (Comple...

You can connect with us on Facebook, links are given below:
Facebook_Page:   / suregatesuccess
Facebook_Group:   / 343481552999674

#Subscribe_Us for more such videos.
Keep supporting keep learning
BEST OF LUCK