Dashboard drill-down performance depends on population and query shape, not extra indexes
General lesson Before adding an index for a dashboard chart drill-down, check three things in order: whether the dimension is already persisted, whether an existing partial composite index matches the active-row predicate and equality-filter order, and whether filters are applie…