Slightly Better Message with Reason for OPTIMIZE Query with Optimize_throw_if_noop Setting Enabled

Why it matters

This feature enhances the feedback provided to users running OPTIMIZE queries by including a detailed reason why the operation did not perform any changes (no-op). It helps users understand why OPTIMIZE did not affect the data, improving troubleshooting and operational clarity.

How to use it

Enable the optimize_throw_if_noop setting before running an OPTIMIZE query. When no optimization can be performed, the query will throw an error message with a detailed reason instead of silently doing nothing.