Missing Tables and Indexes in DB02

Question:

In DB02 transaction diagnosis -> Missing Tables and Indexes has 367 missing optional indexes.

How do I solve this?

Solution:

For optional indexes that have not been created, these optional indexes are delivered by SAP. It is
recommend to ignore the optional indexes because they do not exist on database level.

Now you may ask, what is the use of optional index and where are they required? If you have performance problems while accessing the tables and once you have identified the table, you can check whether these
optional indexes delivered by SAP will enhance the performance by creating them and testing them in QAS or DEV system. If they help to enhance the performance, you can create them in production. If you are
not experiencing any issues, there is no need to create these indexes. Sometimes, these indexes will be created based on the database being used and they are only applied in some specialized functions/situations.
FYI: Opional indexes are stored in the SDBMONDDDB table.

This is an example of how it works:

- Transaction SE11.
- Enter the table(for example) ADRC, choose index of G.  You will see the
   index is marked as 'Non-unique Index' and 'No database index'.
Click on the 'Database system' icon next to it, you will see it is
applicable to the selected database shown there.

If you experience performance problems with these missing indexes,
you may create them by following:

- Transaction DB02
- Checks
- Database <-> ABAP Dictionary
- Recheck
- Click over the index you wish create.
- Click on "Display definition Button".
- Click on "Display & Change" button.
- If the system request a change request or ask for maintain in
  original language, please provide this info.
- Deselect the radio button 'No database index' and select 'Index on
  all database systems' or 'For selected database systems'.
- Save and activate. The index will be created. To refresh the
  missing index list, please repeat the steps 1 - 4.