cancel
Showing results for 
Search instead for 
Did you mean: 

Create index for table in SAP.

former_member268919
Participant
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

manumohandas82
Active Contributor
0 Kudos

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

former_member268919
Participant
0 Kudos

Hello Manu,

Thanks for reply.

I have a question regarding this

Is this what a BASIS administrator has to decide or a developer should create it and then transport it ..

Trev

manumohandas82
Active Contributor
0 Kudos

Hi Trev ,

the Developer should be doing this   after consulting with the concerned functional team .

SAP Basis  normally are not supposed  to touch/modify  any Master or transaction tables in the system .

Thanks ,

Manu

Sriram2009
Active Contributor
0 Kudos

Hi Trev

First identif the transaction or reports enable the transaction code - ST12 trace check the over all ABAP & DB usage,  based on that create the index

BR

Former Member
0 Kudos

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

former_member268919
Participant
0 Kudos

Thanks all for your help.

former_member268919
Participant
0 Kudos


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

Sriram2009
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Trev,

If the create index topic is resolved. Kindly mark the thread as answered. And yes its always better to involve the abapers/Functional guys if its Performance issues for Z programs or expensive sql statements on tables which has large amount of data.

Regards,

Ram