2.1.25. Indices

  • Low/Internal level
  • Index by one attribute
  • For queries selecting by that attribute:
    • Faster tuple access (ordered tuples)
    • Reduces database memory load
      • Small cross product relation, only crosses requisites
    • Accelerates query resolution time
  • CREATE INDEX Index_Name ON RELATION(Attribute);