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

[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!

[Frank-Martin]

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