Explain / Access Plans DB2 - dBforums

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

> Explain / Access Plans DB2

Reply

Search this Thread

#1 (permalink)

Old

07-19-11, 06:19

Breako

Breako is offline

Registered User

Join Date: Jan 2006

Posts: 119

Explain / Access Plans DB2

Hi,
I can view DB2 access plans in DB2 control center. I am just wondering is there any good tip /link anyone has for understanding the various shapes and lingo DB2 is using.

I know what table and index scans are but what about the other shapes / colours?

Also, any good tips for outputting the explain / access plan into a nice text friendly format?

Thanks a mill

Reply With Quote

#2 (permalink)

Old

07-19-11, 06:46

przytula_guy przytula_guy is offline

przytula_guy is offline

Registered User

Join Date: Apr 2006

Location: Belgium

Posts: 1,159

there is a tutorial available
Visual Explain Tutorial

__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be

Reply With Quote

#3 (permalink)

Old

07-19-11, 06:48

Breako

Breako is offline

Registered User

Join Date: Jan 2006

Posts: 119

Brilliant.

This part in particular is what I was after.

IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
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 BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules