Removing and regenerating a MySQL table index

This scenario describes a four-component Job that removes a table index, applies a select insert action onto a table then regenerates the index.