How do you do the EXPLAIN of a dynamic SQL statement?

Question Posted / guest

2 Answers
6299 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do you do the EXPLAIN of a dynamic SQL statement?..

Answer / swetha dasari

we could replace the unknown values with a "?"
eg:

select name

from database

where name = ?

Is This Answer Correct ?

3 Yes

3 No

How do you do the EXPLAIN of a dynamic SQL statement?..

Answer / mehdee

- When we issue an EXPLAIN as of the BIND like EXPLAIN
(YES), then results to analyze the path will go into 3 DB2
tables: PLAN_TABLE, DSN_STATEMENT_TABLE &
DSN_FUNCTION_TABLE. And you can do:
- select * from fhtdev.plan_table; And columns are
defined in DB2 Developers Guide EXPLAIN.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More DB2 Interview Questions

What is the meaning concurrency in the db2 database?

0 Answers

What is the format (internal layout) of ?TIMESTAMP??

1 Answers

Mention the various locks that are available in db2.

0 Answers

Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers Mphasis,

what is the difference between where clause and having clause

2 Answers IBM,

What is difference between rollback and commit?

0 Answers

What is the function of the Data Manager?

2 Answers

What is difference between isnull and coalesce?

0 Answers

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers IBM,

How do I import a csv file into db2?

0 Answers

Can I use LOCK TABLE on a view?

1 Answers

Name some fields from SQLCA

1 Answers

For more DB2 Interview Questions Click Here