Indexes on Oracle Level Missing at Data Dic. (SAP) Level

[Former Member]

Hello Masters,.

My Question is, There are 3 standard tables in CRM server Say for example table A, table B, table C.

Table A has 2 index , B have 1 Index, C has 2 Index in Database level.

These Indexes are not available or somehow deleted from Data Dictionary (SAP) level.

Are these Indexes working if i am writing ABAP Code Select statement or in any situitions...??

[Former Member]

Hi Muhammad,

yes the indexes will be used, because ABAP decides not which index is used for a query, but the database optimizer. And the database does not know anything about the SAP data dictionary.

If you have inconsistencies between database and data dictionary you may have problems when you transport indexes for those tables with names different from the names in the database. Because the database does not allow to create multiple indexes with the same columns and will return an error.

You may fix this soon or when you run into the transport problem. The performance of the database is not influenced either way.

Best regards

Ralph