on 06-11-2008 11:54 AM
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 .
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
69 | |
14 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.