Skip to Content
avatar image
Former Member

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

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...??

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 17, 2007 at 07:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded