5.2.04. Querying

  • Boolean expression complexity
    • heavy WHERE clauses
  • Join complexity
    • Normalised databases, many tables
    • Facts distributed across tables
    • Joins required to answer complex questions
  • Function and Analytic complexity
    • Often require non-DBMS functions
    • Smaller queries with interleaved code