https://community.sap.com/t5/technology-q-a/any-method-to-force-one-specific-sql-statement-to-use-one-specific-index/qaa-p/374005#M29952 Hi Kate,<P>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 ). </P><P>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.</P><P>Regards</P><P>Frank</P> Thu, 23 Mar 2017 07:49:10 GMT Frank-Martin 2017-03-23T07:49:10Z https://community.sap.com/t5/technology-q-a/any-method-to-force-one-specific-sql-statement-to-use-one-specific-index/qaq-p/374004 <P>Dear all,</P><P>Any method to force one specific SQL statement to use one specific index ?</P><P>apart from manually change the statistics of relevant table or index?</P><P>Thanks!</P> Mon, 12 Dec 2016 10:44:03 GMT https://community.sap.com/t5/technology-q-a/any-method-to-force-one-specific-sql-statement-to-use-one-specific-index/qaq-p/374004 Former Member 2016-12-12T10:44:03Z https://community.sap.com/t5/technology-q-a/any-method-to-force-one-specific-sql-statement-to-use-one-specific-index/qaa-p/374005#M29952 Hi Kate,<P>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 ). </P><P>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.</P><P>Regards</P><P>Frank</P> Thu, 23 Mar 2017 07:49:10 GMT https://community.sap.com/t5/technology-q-a/any-method-to-force-one-specific-sql-statement-to-use-one-specific-index/qaa-p/374005#M29952 Frank-Martin 2017-03-23T07:49:10Z