Answer / 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.

Answer / s.v.venkata sivaprasad

explain is the db2 tool which used to improve db2
performance and provides best access path to package

Answer / ryan

Whenever we run a query,DB2 creates an access plan that specifies how it will access the requested data. This is created whenever the sql is compiled at bind time for static sql and before execution for dynamic sql.
DB2 bases the access paths on the SQL statements and also on the statistics and configuration parameters of the system.
Even when an sql is made efficient, it can become inefficient as data grows. So, we need to run DB2 runstats  so as to keep updated statistics . DB2 config and storage can change and plans can be rebound. Db2 explain gives us the info for the plan, package, or SQL statement when it is bound. The output of the EXPLAIN  is stored in user-created table called plan table. Whenever we want to tune a query, we need to go and check the plan table so as to get an idea of the access path DB2 optimizer is using.
http://mframes.blogspot.in/2015/01/db2-explain-and-plan-table-column-names.html

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

What is db2 plan table?

0 Answers  

---

What is meant by the attachment facility?

3 Answers  

---

What does CURRENTDATA option in bind indicate

1 Answers   IBM,

---

How will you delete duplicate records from a table?

7 Answers   Google,

---

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

What is the maximum size of a char data type in db2?

0 Answers  

---

How can you display the current date & current time ?

7 Answers   Cap Gemini,

---

Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,

---

What is the role of the data page in the db2 database?

0 Answers  

---

what is datacom db?

2 Answers   CSC,

---