Summary (Contd.)

• Indexes must be chosen to speed up important queries (and perhaps some updates!).

  • Clustering and Co-clustering are important decisions
  • Performance trade-offs

• The conceptual schema should be refined by considering performance criteria and workload:

  • May denormalize, or undo some decompositions to speed up joins
  • May decompose (vertically or horizontally) speed up selections, projections
  • Redundancy vs. join-inducing IC check

Previous slide

Next slide

Back to first slide

View graphic version