Explain the EXPLAIN statement ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Explain the EXPLAIN statement ?

The explain statement provides information about the optimizer's choice of access path of the SQL.

(Continued on next question...)

Other Job Interview Questions

• What are the various locks available?
• How do you filter out the rows retrieved from a DB2 table ?
• What is the size of a data page ?
• What is an inner join, and an outer join?
• Compare a subselect to a join?
• What is meant by the attachment facility?
• How do you leave the cursor open after issuing a COMMIT?
• What is Maximum number of rows per page
• EXPLAN has output with MATCHCOLS ...
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• More...