SAP中如何创建索引？
目前，我们正在将我们的应用程序与 SAP 连接。我们在 bapi/rfc 方法方面遇到了很多性能问题。所以最近我们正在尝试“直接sql”方法从SAP检索一些数据。不幸的是，我们发现某些 SAP 表没有配备适合我们场景的索引。
我们尝试使用SAPGUI创建索引，但发现真正的“数据库索引”并没有真正创建。使用直接 DDL 创建的索引稍后会导致 SAP 传输机制出现问题。
在 SAP 数据库中创建索引的正确方法是什么？
（我们在 Oracle 数据库上使用 SAP R/3）
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)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
创建索引的正确方法是使用 SE11 事务。应该在开发系统中完成。并输送到QA和生产系统。
更新评论：
1. 确保更改后您已激活该表。转到菜单项实用程序=>版本或类似内容，以确保您的更改已激活。
2.您可以使用事务SE14强制更改（但我认为这只是为了故障排除）。
3.还有其他故障排除步骤我不记得了。您可以在 sdn.sap.com 或 services.sap.com/notes 中搜索 Notes。
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.