Reg:Performance of a DB2 query

156138 · Member Joined: 29 Aug 2006 Posts: 15 Location: Chennai

Can anyone explain how to analyse the performance of a DB2 query
using EXPLAIN (ENDEVOR tool).
_________________
Regards,
Vinod Reddy.

ovreddy · Member Joined: 07 Oct 2006 Posts: 14 Location: Chennai

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.

Krishna · Site Admin Joined: 27 Jan 2006 Posts: 929

Good Information!!!

Thanks,
Krishna

156138 · Member Joined: 29 Aug 2006 Posts: 15 Location: Chennai

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.
_________________
Regards,
Vinod Reddy.

Topics		Replies	Author	Views	Last Post
Related topics
	main & sub programs using the same table !!	1	arrbee	2638	Tue Mar 10, 2009 3:02 pm Anuj Dhawan
	db2 query	4	thiyagucse	5589	Fri Aug 29, 2008 10:31 am Krishna
	How to find out the record length using tso command?	4	bsriram	9119	Fri Oct 26, 2007 12:17 am varun
	how submit cobol,cics,db2 program using jcl	1	pankaj	5608	Wed Apr 12, 2006 12:05 pm arrbee
	How to write a JCL using IEBCOMPR	4	IEBCOMPR	10478	Mon Apr 03, 2006 12:23 pm rangab

	mainframegurukul.com Forum Index -> DB2 SQL - DB2 PROGRAMMING	All times are GMT + 5 Hours
Page 1 of 1