Subsequent Tuning
The system runs fine for a week, so you take a vacation. When you return….
- General performance complaints abound
- you rebuild indices
- you create and update statistics
- you check optimizer plans
- Q3 is still particularly bad, and the league president wants it to be fast.
- you wisely decide to give him what he wants
- you denormalize to achieve a precomputed join