Auto Optimize = automatically reduces small files during writes. Best for ongoing ETL.

OPTIMIZE = manual compaction + Z-ORDER for improving performance on existing data.

They are complementary, not competing.

Most teams use Auto Optimize for daily ingestion and still run scheduled OPTIMIZE jobs weekly or monthly for Z-ORDER and deep compaction.