Optimizer, Static SQL, Dynamic SQL like there are many specific keywords in DB2. Explained for you to read quickly.
The optimizer in DB2 is a main task that saves time and money. How DB2 optimizer works you need to know for DB2 SQL.
Optimize and Fetch in DB2 why and when to use these clauses explained.