Page 1 of 1

Reg:Performance of a DB2 query

Posted: Fri Sep 15, 2006 4:07 pm
by 156138
Can anyone explain how to analyse the performance of a DB2 query
using EXPLAIN (ENDEVOR tool).

Posted: Sat Oct 07, 2006 4:30 pm
by ovreddy
Hi,

EXPLAIN statement inserts a row into PLAN TABLE usually named as PLAN_TABLE. This table contains several columns used to estimate cost for executing a query.

After executing EXPLAIN. Use select statement on PLAN_TABLE to see the cost of execution.

Thanks,
Reddy.

Posted: Mon Oct 09, 2006 10:43 am
by Krishna
Good Information!!!



Thanks,
Krishna

Posted: Wed Nov 15, 2006 12:43 pm
by 156138
Reddy, Thanx for information , i know that the results will be put in a PLAN_TABLE.

When you select * from PLAN_TABLE depending on which column will u able to decide the query is ok.

One thing is depending on index usage.

Second there are two cost columns PROCMS and PROCSU.
Do you know the maximum possible values for the above two columns,so that we can able to tell the query is performing well.