There is one more drawback with optimize with zorder ie it's requires down time for execution on production as it blocks concurrent writes on the delta table.