Explain the EXPLAIN statement?

Question Posted / guest

Explain the EXPLAIN statement?..

EXPLAIN, determines the access path that will be used by
DB2 to execute that particular SQL statment. The results
are written to the PLAN table.

Is This Answer Correct ?

1 Yes

1 No

More DB2 Interview Questions

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

cobol-db2 runjcl please?

wt is view ? wht r the restrictions for view ?

When will you chose to run RUNSTATS?

What r the comman abends in db2, jcl and cobol???????

What is the syntax for FETCH in DB2 ?

could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

How do you filter out the rows retrieved from a Db2 table ?

What is a base table?

What is a clustering index?

What happens to a cursor after a commit?

What is a Resource Control Table(RCT)? Describe its characteristics.

For more DB2 Interview Questions Click Here