This topic has been locked.
1 reply Latest Post - 2012-12-28T07:01:07Z by zhaoguob
Pinned topic Explain Package
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
how could i interpret this output of this command.How it useful for Query Tuning?
Updated on 2012-12-28T07:01:07Z at 2012-12-28T07:01:07Z by zhaoguob
zhaoguob 27000256SM3 PostsACCEPTED ANSWER
Re: Explain Package2012-12-28T07:01:07Z in response to SystemAdminThe EXPLAIN PACKAGE command will populate the explain access data into the PLAN_TABLE that is owned by the current user. It indicate how the data is accessed by the db2, such as using index scan or table scan. You can also use Data Studio Query Tuner to review the explain access data in graph or text. The attachment is a sample.
The data populated into the explain tables(PLAN_TABLE) is very useful for query tuning. It indicates if the current access plan is good or not, if the created index is used by DB2, and how the index is being used, and so on.