This was extracted from a
[discussion in Slack (internal)](https://gitlab.slack.com/archives/C02JRAY273M/p1726109023032769).

The discussion was primarily to come up with consensus that are often
stuck with the tradeoff between too many indexes and list views that
timeout. So this documentation makes that tradeoff explicit.