on 01-21-2015 11:02 AM
Hello,
While analysing EWA we came across a expensive statement. When checked with Execution plan button it showed FULL table scan.
I need to create an index for the table.
Kindly suggest.
Hi Trev
If you serach in SCN you will get lots of forums for this
Creating Indexes - SAP NetWeaver Composition Environment Library - SAP Library
Please be aware that the index needs to be transported to production only at a quiet time when possibly the usage of the table is very less
Thanks ,
Manu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Trev,
Based on the analysis mentioned by Sriram, You can use transaction se14 to create index or using se11 provide the table name and then in the top menu option on right hand side you can see a index button after clicking that you can see all existing indexes on that table and from there you can create one and create a TR which you can use to move it to Production systems later.
Regards,
Ram
Hi Ramkrishna,
I feel that ABAPer and Functional should be involved for creating index also i found useful note which has prerequisites for creating indexes
334224 - Important notes for creating indexes
Hi Trev
If your are finding the performance issue, as basis team can enable the ST12 trace of any reports/ transaction code, check the over all the db usage, and then jointly you can take finial action to create index or ABAPer / Function guy take any other alternative action.
You can refer the SCN thread how to use the ST12 trace
BR
SS
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.