By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,288 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,288 IT Pros & Developers. It's quick & easy.

explain Plan

P: 3
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
Share this Question
Share on Google+
1 Reply


nearestniladri
P: 5
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.