The HDB_DBCC_MTABID event is used in SAP to missing tables and indexes for the HANA DB.
Potential Use Cases
This event could be used in the following scenarios:
Correlate missing tables and indexes to poor SQL query performance or transaction failures.
Identify performance improvements after code changes move in the environment.
The event will look like this in Splunk:
Execute the dbacockpit transaction in the system. Open the Diagnostics folder and double-click on “Missing Tables and Indexes”. The information displayed on the right side of the screen will match the data that is extracted and sent to Splunk.