title: How to create index in SAP?
body: <p>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 &quot;direct sql&quot; 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.</p>
  <p>We've tried creating index with SAPGUI, but found that the real &quot;database index&quot; was not actually created.  Index created with direct DDL will later cause trouble with SAP transport mechanism.</p>
  <p>What is the proper way to create an index in SAP database ?</p>
  <p>(We are using SAP R/3 on Oracle Database)</p>