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

Once you create a view, where would information about the view be stored?

what is the difference between where clause and having clause

What is dbrm in db2 database?

what is a plan and how do you refer the plan in the program?

What is the connection string to connect to the DB2 Database ?

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

Can we declare DB2 HOST variable in COBOL COPY book?

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

What is the role of schema in the db2 database?

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

What is the picture clause of null indicator variable?

Which isolation level provides highest data integrity?

For more DB2 Interview Questions Click Here