There are numerous reports under the "Databases" tab
When you first click on the "Databases" tab you are taken to the list of databases in this report
Clicking on a database displays this overview report.
This report shows the data and log files for the selected database.
All tables, showing number of rows and space used for data and indexes
A list of tables without a primary key, tables with no clustered index, and foreign keys with no supporting index.
There are several reports for database indexes.
A list of all procedures and triggers using index scans, hash matches, sorts, filters, parallel plans and more.