Database indexes

Code No
Skill Category No: 
8
Skill No: 
1
Topic No: 
9
Level: 
II
  • Concept of index
  • Principle of index
    • Algorisms of retrieval
  • Implementation of index
    • Physical structure
    • Performance
    • Recovery characteristics of index.
  • Features, advantages and disadvantages with various types of index
    • Binary tree (B tree)
    • Index-organized tables
    • Bitmap index
    • Reverse key index
    • Hash cluster (hash index)