A wave planning list in a WMS application took about six seconds to return one page of results. This note records the investigation path and the evidence behind the final optimization direction.

Identifiers and environment details have been anonymized. The SQL shape, measurements, and decisions are …