How to create index in SAP?

oracle indexing sap-data-dictionary sap-r3
Sake picture Sake · Nov 28, 2009 · Viewed 10.4k times · Source

Currently we are interfacing our application with SAP. We are having a lot of performance problems with bapi/rfc approach. So recently we are trying "direct sql" approach to retrieve some data from SAP. Unfortunately, we've found that some of SAP table does not equipped with proper indices for our scenario.

We've tried creating index with SAPGUI, but found that the real "database index" was not actually created. Index created with direct DDL will later cause trouble with SAP transport mechanism.

What is the proper way to create an index in SAP database ?

(We are using SAP R/3 on Oracle Database)

Answer

Igal Serban picture Igal Serban · Nov 28, 2009

The proper way to create index is using the SE11 transaction. It should be done in the development system. And transported to the QA and production systems.

Update to comment:
1. Make sure you have activated the table after the change. Go to the menu item Utilitys=> Versions or somthing like that to make sure your changes were activated.
2. You can use transaction SE14 to force the change ( But I think it's only for troubleshooting).
3. There are other troubleshooting steps that I don't remember. You can search for notes int sdn.sap.com or services.sap.com/notes.

Related questions

Force index use in Oracle

I encountered this question in an interview and had no clue how to answer: There is a table which has a index on a column, and you query: select * from table_name where column_having_index="some value"; The query …

Read More
Oracle - Select where field has lowercase characters

I have a table, users, in an Oracle 9.2.0.6 database. Two of the fields are varchar - last_name and first_name. When rows are inserted into this table, the first name and last name fields are supposed to be in …

Read More
Do I need to create indexes on foreign keys on Oracle?

I have a table A and a table B. A has a foreign key to B on B's primary key, B_ID. For some reason (I know there are legitimate reasons) it is not using an index when I join …

Read More