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

Reading an explain Plan

P: n/a
I am running explain plans on different SQLs and need some help reading
the output. Is there a document that will help me understand this? Any
help will be appreciated.
Thanks

Apr 4 '06 #1
Share this Question
Share on Google+
15 Replies


P: n/a
db2freak wrote:
I am running explain plans on different SQLs and need some help reading
the output. Is there a document that will help me understand this? Any
help will be appreciated.
Thanks

I sent you a pdf to the gmail address.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Apr 4 '06 #2

P: n/a
Serge Rielau wrote:
db2freak wrote:
I am running explain plans on different SQLs and need some help reading
the output. Is there a document that will help me understand this? Any
help will be appreciated.
Thanks

I sent you a pdf to the gmail address.

Cheers
Serge

Hi!

Can you please send that PDF to me too ?

Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
| Gregor Kovac | Gr**********@mikropis.si |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
Apr 5 '06 #3

P: n/a
Serge
it would be a good idea to post the link for this document so that we all
can get it.

regards
krishna j

"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:49************@individual.net...
db2freak wrote:
I am running explain plans on different SQLs and need some help reading
the output. Is there a document that will help me understand this? Any
help will be appreciated.
Thanks

I sent you a pdf to the gmail address.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Apr 5 '06 #4

P: n/a
Agreed. I was about to request the document ... is there any public
link ?

Thanks.

Apr 5 '06 #5

P: n/a
Michel Esber wrote:
Agreed. I was about to request the document ... is there any public
link ?

Thanks.

Well. I'd love to.
Here is the title:
D13: Analyzing Query Access Plans In DB2/LUW Using Explain
by John Hornibrook, IDUG NA 2004
Unfortunately I can't find the beast in the IDUG Technical library.
And this link served up by google:
http://www.idug.org/idug/member/jour...1/articl05.cfm
Doesn't work for me....

Anyone having better luck?
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Apr 5 '06 #6

P: n/a
In article <49************@individual.net>, sr*****@ca.ibm.com says...
Michel Esber wrote:
Agreed. I was about to request the document ... is there any public
link ?

Thanks.

Well. I'd love to.
Here is the title:
D13: Analyzing Query Access Plans In DB2/LUW Using Explain
by John Hornibrook, IDUG NA 2004
Unfortunately I can't find the beast in the IDUG Technical library.
And this link served up by google:
http://www.idug.org/idug/member/jour...1/articl05.cfm
Doesn't work for me....

Anyone having better luck?
Serge


Instead of clicking the real link after the Google search, you can read
the 'cache' version without a problem.
Apr 5 '06 #7

P: n/a
Nice ... Just for the records: http://tinyurl.com/mgdpw

Apr 6 '06 #8

P: n/a
thanks Michel!
this link works - and a useful article

krishna j

"Michel Esber" <mi****@us.automatos.com> wrote in message
news:11*********************@g10g2000cwb.googlegro ups.com...
Nice ... Just for the records: http://tinyurl.com/mgdpw

Apr 7 '06 #9

P: n/a
Michel,

I do not see the article as soon as I click on the link you provide:
http://tinyurl.com/mgdpw

This is what I got:
Sua pesquisa -
cache:bqE9DrG1gdIJ:http://www.idug.org/idug/member/jour...1/articl05.cfm
DB2 John Hornibrook - não encontrou nenhum documento correspondente.

Would you check if the link is still ok?

Thanks!

krishan wrote:
thanks Michel!
this link works - and a useful article

krishna j

"Michel Esber" <mi****@us.automatos.com> wrote in message
news:11*********************@g10g2000cwb.googlegro ups.com...
Nice ... Just for the records: http://tinyurl.com/mgdpw


Apr 10 '06 #10

P: n/a
In article <11**********************@i40g2000cwc.googlegroups .com>,
ne*****@hotmail.com says...
Michel,

I do not see the article as soon as I click on the link you provide:
http://tinyurl.com/mgdpw

This is what I got:
Sua pesquisa -
cache:bqE9DrG1gdIJ:http://www.idug.org/idug/member/jour...1/articl05.cfm
DB2 John Hornibrook - não encontrou nenhum documento correspondente.

Would you check if the link is still ok?


It looks like Google removed it from their cache also. It now depends on
Serge sending the pdf, or resending it by others who already got a copy
if this is allowed by Serge?
Apr 10 '06 #11

P: n/a
Gert van der Kooij wrote:
In article <11**********************@i40g2000cwc.googlegroups .com>,
ne*****@hotmail.com says...
Michel,

I do not see the article as soon as I click on the link you provide:
http://tinyurl.com/mgdpw

This is what I got:
Sua pesquisa -
cache:bqE9DrG1gdIJ:http://www.idug.org/idug/member/jour...1/articl05.cfm
DB2 John Hornibrook - não encontrou nenhum documento correspondente.

Would you check if the link is still ok?


It looks like Google removed it from their cache also. It now depends on
Serge sending the pdf, or resending it by others who already got a copy
if this is allowed by Serge?

I'm in no position to allow or disallow anything.
Presumably copyright rests with IDUG.
Now, I can't imagine IDUG taking issue with passing a popular talk
around as long as no-one places it on a their webpage for download.
Maybe those with an interest should email IDUG to inquire why this page
doesn't come up?
In the meantime those who want the talk can send me email and I'll pass
it along.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Apr 10 '06 #12

P: n/a
Udo
Yo can get the page from the web-archive

http://web.archive.org/web/200406030...1/articl05.cfm

Regards,
Udo

--
Speedgain for DB2 - The DB2 Monitor
http://www.itgain.de/en/index.html

Apr 10 '06 #13

P: n/a
Udo wrote:
Yo can get the page from the web-archive

http://web.archive.org/web/200406030...1/articl05.cfm

Regards,
Udo

Danke Udo,

See you in The Hague?

Gruss
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Apr 10 '06 #14

P: n/a
Udo
> Danke Udo

Wow - your german makes progress :-)
See you in The Hague?


Not me. But someone of the Speedgain crew will be there.

Gruss
Udo

--
Speedgain for DB2 - The DB2 Monitor
http://www.itgain.de/en/index.html

Apr 10 '06 #15

P: n/a
Udo wrote:
Danke Udo


Wow - your german makes progress :-)

oh, oh.. ist's die Eifel oder die Pfalz die durchschlaegt?

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Apr 10 '06 #16

This discussion thread is closed

Replies have been disabled for this discussion.