Summary: What to do Next

If you found…

• Bad access paths: Add indexes or rewrite joins.
  • You won't be able to add indexes to replicated objects
• Mismatched estimates: Check stats and consider histograms.
• Temp spills: Filter earlier.
• Wrong join type: Add hints or use a different query shape.
• Stale plans: Consider SQL plan baselines or profiles.