Skip to Content
Former Member
May 27, 2009 at 02:56 PM

Index for performance question


I have a few applications that I am trying to tweak to gain better performance. I would like to try a few indexes based upon my analysis and also data coming from the System i SQL cache and index advisor. My question is this: Does the SAP system look at indexes differently based upon whether they were created within the SAP system (SE11) versus just creating them at the OS level. I want to try some indexes but I don't want to define them to SAP until I see that they are doing some good. I would just like to add them at the OS level, run the transaction and see if it helped. If it does help, then I can define them to SAP.

Best regards,

Russ Cook