Where is the output of EXPLAN stored?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

Where is the output of EXPLAN stored?

In USERID.PLAN_TABLE

(Continued on next question...)

Other Interview Questions

• What is a LIKE table and how is it created?
• What is SQLcode - 811?
• What is a data page?
• I need to view the number of tables existing under one particular OWNER. ?
• Where is the access path logic created by the DB2 Optimizer stored?
• What is the difference between IN subselects and EXISTS subselect?
• What are the disadvantages of PAGE level lock?
• Which catalog tables contain authorization information?
• If I have a view which is a join of two or more tables, can this view be updatable?
• What does the SQLcode of -818 pertain to?
• More...