user exit, secondary key

[Former Member]

hi friends,

1.there r so many ways to find user exit can any one suggest me which is easy and helpful method

2.will performance increase if we use secondary index r key in select query

plz explain me with eg code how to assign secondary

thanks

regrads,

soorya

[former_member181962]

Go to se93 and give the tcode to find the main program associated to it.

Go to se38 and give the main program.

Find the package associated to it.Go to->Object Directory Entry.

Go to smod transaction.

Press f4.

Press Information System Button.

Give the Project(Dev Class).

Press enter.

Find the enhancements associated.

Regards,

Ravi

[abdul_hakim]

hi there are lots of differences are there between customer exits and user exits.

to find user exits search for the term PERFORM USEREXIT in your application program.

to find customer exit search for the term CALL CUSTOMER in your application program and then check the documentation to find out whether it will suit ur requiremet..

using secondary index will improve ur performance provided you have used it in a better mannner coz a worst secondary index may lead to perform issue in which case it is better than none at all.

check the doucment under http://help.sap.com for knowing about the points to keep in mind while creating the secondary indexes.

Cheers,

Abdul Hakim

[Former Member]

Hello Soorya,

Yes there are many ways of finding a user exit...

One way is go to SMOD and press F4, then select SAP application and then proceed as per your req.

Second is find out the package name for the transaction and then use SE84, click on enhancement and then enter the package name and execute.

Third is search the SDN site for user exit and u will come accross a program which will give u list of all exits for a transaction.

About ur second question, performance increases when the where clause in the select stmt is same as the key (primary or alternate). The database automatically selects the best index based on the its own logic. However u can find out using trace if it has selected the correct index. If you want to force the DB to use specific index then u can use HINT stmt to suggest.