oracle 如何在SAP中创建索引？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1812201/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to create index in SAP?
提问by Sake
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.
目前，我们正在将我们的应用程序与 SAP 连接起来。我们在使用 bapi/rfc 方法时遇到了很多性能问题。所以最近我们正在尝试“直接 sql”方法来从 SAP 检索一些数据。不幸的是，我们发现某些 SAP 表没有为我们的场景配备适当的索引。
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.
我们尝试过用 SAPGUI 创建索引，但发现真正的“数据库索引”实际上并没有被创建。使用直接 DDL 创建的索引稍后会导致 SAP 传输机制出现问题。
What is the proper way to create an index in SAP database ?
在 SAP 数据库中创建索引的正确方法是什么？
(We are using SAP R3 on Oracle Database)
（我们在 Oracle 数据库上使用 SAP R3）
回答by Igal Serban
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.
创建索引的正确方法是使用 SE11 事务。它应该在开发系统中完成。并运送到 QA 和生产系统。
Update to comment:
1. Make sure you have activated the table after the change. Go to the menu item Utilitys=> Versionsor 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.
更新评论：
1. 确保您在更改后激活了表。转到菜单项Utilitys=> Versions或类似的东西，以确保您的更改已激活。
2. 您可以使用事务 SE14 来强制更改（但我认为这仅用于故障排除）。
3. 还有一些我不记得的故障排除步骤。您可以搜索 notes int sdn.sap.com 或 services.sap.com/notes。
