In Db2 , optimizer selects most optimum access path. Sometimes, your query taking longer cpu time, then, you can influence the default hint. In Oracle, we can add optimizer HINT into SQL. Ex: SELECT * /*+ USE_ NL */ FROM S_EMP; Related3 Types of HINT in DB2 to Read now But, in DB2 the process is … Continue reading DB2- Optimization Hints