explain Plan

[thescript786]

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

[nearestniladri]

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.