Generating Application Indexes on CDB Tables
The middleware service generation you performed has created and changedqueries on application tables. In order to improve the performance ofthese queries it is useful to create table indexes and to delete tableindexes that are not anymore necessary. This program scans thedatabase for indexes and displays all indexes of tables that arerecommended to be changed and are therefore marked. If a table must beadjusted all indexes of that table are displayed together with theaction that should be performed and a description why a new index isneeded. By unmarking indexes these are excluded from the databaseadjustment. When pressing 'Adjust Indexes' you first have theopportunity to save unmarked index field combinations in the exceptiontable TGN_INDEX_EXC. These table entries will be transported. Theentries of the exception table prevent the indexes from being displayedthe next time. An Index combination is displayed again if the entry isdeleted from the exception table (Transaction SM30). Mark the exc
eptions. 'Continue' will start the generation/deletion of indexes,'Cancel' will cancel the program. The detailed result can be displayedvia transaction SMOGLOG which is also accessible as a push button onthe start screen.
The indexes will not be transported. That means you should execute thistool on all CRM servers in your system landscape.
You can also create manually entries in the exception tableTGN_INDEX_EXC, forcing this program to create or not to delete indexesthat were not calculated by itself. Use transaction SM30 and enter yourvalues. Choose a table key in your prefix namespace ('X' and 'R' arereserved for generation). The index fields are separated by '+'.