Re: Rebuilding vs. Optimizing Partition, Time Elapsed to complete

[Rick James]

Perhaps rebuilding the indexes was using the key_buffer instead of doing a file sort.
SHOW VARIABLES LIKE '%size%';