Thanks for the reply @BeardOverflow. Shouldn’t its default option be RECREATE_QUIETLY? As it won’t modify the DB unnecessarily. Not sure why the default value is dropping the unique indexes first and then create. Anyway, Thanks 
it clarifies my question.