Database experiments are needed when you
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