cancel
Showing results for 
Search instead for 
Did you mean: 

how to create table level index.

Former Member
0 Kudos

Hi All,

I have written a program for c-form tracking , where i used purchasing tables like EKBE , EKKO and accounting tables , BSEG and BKPF.BSEG isa cluster table . it is taking execution time more at database level , so if i create a index on tables is it useful to increase the performance if so please inform me how do i create index .

please it is very urgent .

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Shilpa,

Creating the index will solve the purpose if your select statements are going to use that filed for which you are going to create the index.

Instead of using the cluster table like Bseg try to find the alternative tables for your requirement, i think that will definitely improve the performance.

Steps for creating the index are as follows

Yo have to use trx SE11 into Dev system.

Enter the database table name and press

Display -> Indexes -> Create

Enter index name.

Choose Maintain logon language.

Enter short description and index fields.

Then press save and create the request to transport the index to QA and

PRD.

Then press activate.

Regards,

Viveks

Former Member
0 Kudos

Hi vivek ,

I have no option , so i used bseg table , if i create index on this table performance of report will be increased , so how do i call this index in the report.can u please expalin me in deatil

Thanks & Regards

Shilpa .P

jiteshmehta
Active Contributor
0 Kudos

Hi Shilpa

You can make any field an index.

You will do this in SE11 for the tables in CHANGE mode and pushing the INDEXES button on the table field display screen.

Regards

Jitesh