What will the DB2 optimizer do?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What will the DB2 optimizer do?

The optimizer is a a DB2 component that processes SQL statements and selects the access paths.

(Continued on next question...)

Other Interview Questions

• What does the SQLcode of -818 pertain to?
• When does the SQL statement gets executed when you use cursor in the application programming ?
• What is a DB2 access path?
• Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
• Describe what a storage group (STOGROUP) is?
• How do you retrieve the data from a nullable column?
• What is cursor stability?
• What are the levels of isolation available with DB2V4?
• What is a synonym ? How is it used ?
• What happens to the PLAN if index used by it is dropped?
• More...