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
- 18382 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
Mention some fields that are a part of sqlca.
Is it possible using max on a char column?
What is the maximum number of columns in a db2 table?
What is the result of open cursor statement?
Which component is responsible for db2 startup and shutdown?
Is db2 a programming language?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is the role of union all and union
How do I change the column size in db2?
What does db2 stand for?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How to restart a DB2 program?
What is view db2?
What is package in cobol db2?
How do I connect my db2 database to ibm?
