[EPIC] TMS optimizer next improvements

### Describe the proposal

Track follow-up improvements for TMS optimizer to improve compaction coverage and reduce metrics configuration complexity in real environments.

Scope of this epic:
- Expand partition transform support in compaction flow.
- Normalize built-in metrics naming for easier monitor rule configuration.

### Task list

- [ ] #10358
- [ ] #10359
- [x] #10115
- [ ] #10394

Start by reviewing the TMS optimizer context and the linked tasks #10358, #10359, #10115, and #10394; the issue names no files, tests, or entry points. Done means completing the remaining task-list items for partition-transform support and normalized built-in metrics naming, with improved compaction coverage and simpler monitor rule configuration.

Written by the indexing model from the issue text.