### Search before asking - [x] I have searched in the [issues](https://github.com/apache/amoro/issues?q=is%3Aissue) and found no similar issues. ### Description Introduce event-driven metrics from loaded metadata to determine if scans are needed. - Analyze partition file size MSE from the loaded metadata. - Trigger scans only if metrics indicate optimization necessity. ### Parent issue #3774 ### Are you willing to submit PR? - [x] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)