Skip to Content
0

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

Dec 12, 2016 at 10:44 AM

70

avatar image
Former Member

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Frank-Martin Haas
Mar 23, 2017 at 07:49 AM
0
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

Share
10 |10000 characters needed characters left characters exceeded