Explain plan

[val02]

Hi All

I am learning DB2, I want to know is there is anything similar to Explain plan in Oracle, which can be used to view the statistics for the query like..physical read, sorts, whether query is using indexes etc....

Thanks and Regards

Val

 

[maxtardiveau]

Hi Val,

there is indeed. The best way to get started is to use the Command Center. Connect to your database, then enter a query and select Script->Create Access Plan.

If the explain tables have not been created before, you'll need DBA access to do that.

There are entire books written about this topic. See the DB2 docs, Administration Guide : Performance, chapter 7 for (much) more detail.

Let me know if you run into any problem.

-- Max