Re: Way To Generate Readable Explain Plan?

Re: Way To Generate Readable Explain Plan?

This is a discussion on Re: Way To Generate Readable Explain Plan? within the DB2 forums, part of the Database Server Software category; --> You can write some sql script to query explain tables. DB2 does suggest use db2 tools which can give ...

		Unix Technical Forum > Database Server Software > DB2
Re: Way To Generate Readable Explain Plan?

#1 (permalink)

02-26-2008, 11:00 AM

Fan Ruo Xin

Posts: n/a

Re: Way To Generate Readable Explain Plan?

You can write some sql script to query explain tables.
DB2 does suggest use db2 tools which can give more helpful information about
access plan.
Regards,
FRX

Carlos Rodriguez wrote:

> Is there an SQL script that can read the information from the Plan table and
> format the results so that it can be interpreted easily?

« DB2 connect V7.2 fp 8 install problem | Help!!! Backup pending state after delete from table »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 09:18 PM.