When breaking the rules is the right call

• A

  Denormalise the schema so the six tables become one wide table

• B

  Add indexes until the join is fast enough

• C

  Keep a precomputed summary table, refreshed when the data changes

• D

  Cache the rendered dashboard in the application for a few minutes