sql: meta issue for enabling partial statistics collection "at extremes"

[Uzair5162]

This issue will serve as the meta-issue for making partial statistics collection "at extremes" production ready and enabling it by default.

• [x] https://github.com/cockroachdb/cockroach/issues/93094
• [ ] https://github.com/cockroachdb/cockroach/issues/99377
• [ ] https://github.com/cockroachdb/cockroach/issues/94101
• [x] https://github.com/cockroachdb/cockroach/issues/126401
• [ ] https://github.com/cockroachdb/cockroach/issues/95233

Jira issue: CRDB-39681

[blathers-crl[bot]]

Hi @Uzair5162, please add a C-ategory label to your issue. Check out the label system docs.

_{:owl: Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}