469,270 Members | 1,174 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

explain Plan

Hi,

I am new to DB2. I am using DB2 V8.1 how to find cost of a query?
In dB2 Is there is any similar command like explain plan in oracle?

Thanks in Advance,
Karthick
Nov 20 '07 #1
1 1633
If you are using DB2 8.1 then you need to follow the following steps:

1. Go to Command Center
2. Go to script tab.
3. Write your SQL statement
4. Then goto Script menu.
5. Click on the option like Access Plan or generate access plan.
Nov 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

14 posts views Thread by Ina Schmitz | last post: by
reply views Thread by JAW | last post: by
5 posts views Thread by kabotnet | last post: by
3 posts views Thread by raviva | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.