The MaxDB documentation does not contain any information about MaxDB hints. i want to know that what is a database hint?
If anyone is familiar with it then please suggest me the valid thing.
Usually, the SQL optimizer determines the access path (for example, index access or full table scan or key range) based on costs (cost-based optimizer).
To override this mechanism, you can specify explicit hints for an SQL statement to force a specific access path. Since hints override the cost-based SQL optimizer, you should only use them for diagnosis or in emergencies. Hints are a means of correction where there is no other solution. Only use them with caution and after prior consultation with experienced SAP MaxDB Support staff.
Sign up for STechies
Ask Question From Our Experts