A plan that used to be good

• A

  The index fragmented during the load and needs rebuilding

• B

  The newly added rows no longer fit in memory, which forces a different join strategy

• C

  The optimiser is planning from statistics gathered before the load

• D

  Nested loop joins are always slower than hash joins