Separate critical-path removal from index changes
For a database-backed detail page, first remove avoidable blocking work, consolidate duplicate reads, narrow projections, and add measurement before changing indexes. Defer secondary data only when it is not required for authorization or the primary decision. Measure each enviro…