Support OPTIMIZE Query on Joined Tables to Reduce Memory Footprint

Why it matters

This feature enables users to optimize Join tables, which helps in reducing the memory usage associated with them, improving resource efficiency during query execution.

How to use it

Users can apply this feature by executing the OPTIMIZE query on their Join tables like this:

OPTIMIZE TABLE <join_table_name>;