cs614 lecture 26 Conventional Indexing Techniques
In this lecture we will cover following topics:
Need for Indexing: Speed
Need For Indexing: I/O Bottleneck
Indexing Concept
Indexing Goal
Conventional indexes
Dense index concept
B-tree Indexing
Hash Based Indexing
Hash Based Indexing: Concept
B-tree vs. Hash Indexes
Primary Key VS Primary Index:۔۔