Interested to Buy Any Domain ? << Click Here >> for more details...
How do you do the EXPLAIN of a dynamic SQL statement?
- 2 Answers
- 6057 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is a predicate?
In terms of DB2 indexing, what is the root page?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
select 100 records from million records ?
Where is the access path logic created by the DB2 Optimizer stored?
What is a collection in db2?
What is REORG? When is it used?
Highlight all the advantages that are attached to a package.
How would you find out the total number of rows in a db2 table?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What is node in db2?
What is database reorganization?
COBOL 
