Interested to Buy Any Domain ? << Click Here >> for more details...
What is an EXPLAIN in DB2.
How and what is the steps followed in EXPLAIN command. Can
all the queries be used in EXPLAIN command to check the
performance.
- 3 Answers
- 18557 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
>>Explain can be used to improve the performance of queries.
>>Explain command populates three tables
PLAN_TABLE,DSN_STATEMNT_TABLE,DSN_FUNCTION_TABLE. These
tables contains various info about the queries which can be
used for improving the performance.
>>Step1:PLAN_TABLE must be created.
>>Step2:Use explain sql or explain option in Bind to
populate the tables.
>>For example,explain plan set queryno=01 for select empname
from employee;
This would populate plan and statement table.Assigned
queryno would be 01.
>>Alternately EXPLAIN(YES) in BIND option.
>>Only select,insert,update,select for update,delete, delete
current of cursor,update current of cursor can be used in
explain.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Can we insert update delete in view?
What is cursor in dbms?
How to find the maximum value in a column in the db2 database?
How can you classify the locks in db2?
What do you mean by rollback?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How can we retrieve the total number of records in RPG & CLLE?
What is dbrm? What it contains?
How to compare data between two tables in db2?
Explain the function done by data manager?
Which components manage deadlocks in db2?
Define check constraint.
How to access db2 tables in mainframe?
Where do you specify them?
How do I add a column in db2?
