Functionality The function module collects data from the mySAP ERP databaseperformance tables about statement where the DB Optimizer advisedindexes. This data is displayed in transaction ST04, Detail Analysis Menu,Indexes Advised (the report executed is RSDB4IDA>).Use The table parameters IDA_0100, IDA_0200 and IDA_0300 are used forexporting information only. Data in them handed to the function modulewill be removed. The table parameter TABLES_FOR_DETAILS is used for importing tables forwhich detailed information about indexes advised on them is requested. The table parameter IDA_0100 will contain overview information abouttables for which the DB Optimizer advised indexes if the function moduleis called using this parameter (see reference structureDB4IDA0100>). The table parameter IDA_0300 will contain summary information aboutwhich indexes were advised on which tables if the function module iscalled using this parameter (see reference structureDB4IDA0300>). The table parameter TSC_0200 will contain detailed information abouttable scans performed on all tables listed in TABLES_FOR_DETAILS (seereference structure DB4IDA0200>).Example Exapmles on how to call the function module is to found inRSDB4IDA>. |