ALTER TABLE tablename AUTO_INCREMENT = 10000000
This query is taking long time to update. Why? I need to optimize this query.