Skip to Content
avatar image
Former Member

Any method to force one specific SQL statement to use one specific index ?

Dear all,

Any method to force one specific SQL statement to use one specific index ?

apart from manually change the statistics of relevant table or index?

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 23, 2017 at 07:49 AM
    Hi Kate,

    DB2 optimizer guidelines can be used to influence the access plan chosen by the DB2 optimizer. In an SAP environment those guidelines can be applied via OPEN SQL hints ( note 868888) or via SAP optimizer profiles ( note 1818503 ).

    Hints have the advantage that they can easily be transported with the APAP code. Profiles can be tested without changing the SAP ABAP code. So both mechanisms are sometimes useful.

    Regards

    Frank

    Add comment
    10|10000 characters needed characters exceeded