Add or remove indexes

For a new DB schema change, want to validate it and estimate migration time

Want to verify some query optimization ideas

Tune database configuration parameters

Do capacity planning and stress-test your DB in some environment

Plan to upgrade your DBMS to a new major version

Want to train ML model related to DB optimization