SAP ABAP Forum
Hello SAP Experts,
Can anyone tell me that what does the SAP parameter dbs/ada/use_hints do?
Please help me if possible.
Thanks in Advance!
The parameter determines whether hints are generated for the cost-based SQL optimizer in SAP MaxDB for certain types of SQL statements.
The parameter value ABAP->0 means that no optimizer hints are generated.
For other values, hints are normally generated.
If you use the parameter ABAP->1, hints are activated in accordance with standard parameters and are transferred to the database.
As of the Web AS 6.40 kernel version, this parameter is set to ABAP->1, which means that the customer no longer has to set the parameter explicitly in the profile.
Sign up for STechies