3.6.11. Optimise (Indexing)

  • Giving the Optimiser hints
  • Indexing
    • Simple - single attribute
      • Index(A)
      • Reduce sparse domains (e.g. text)
    • Composite - multiple attributes (typically pairs)
      • Index (A,B)
      • Some subtleties in here