Over time, your database (where all your sites information & settings are stored) can build up a collection of unneeded data such as post revisions, spam comments, trash, transient options, orphaned meta data, and so on.
So maintaining & optimising your database means faster backups, easier restorations and improved speed & performance.
Essentially its like giving your website a spring clean.