Hi,
One problem with this approach (changing SP's to execute block) is that you
still have the possibility of doesn't getting called SP plans (SP's called by
the SP which you are converting to an execute block).
Att.João Paulo
DE: "liviuslivius liviusliv...@poczta.onet.pl [firebird-support]"
<firebird-support@yahoogroups.com>
Para: "firebird-support@yahoogroups.com" <firebird-support@yahoogroups.com>
Enviadas: Quarta-feira, 1, Junho 2016 7:27:34
Assunto: Re: Re: [firebird-support] Stored Procedures Execution Plan
Hi, yes but this was "wrong"Consider this:inside procedure you have 5
different statementsand you run query and only two of them are reached - do you
really need to see all 5? Ok - now you got only "natural" word for procedure -
i do not know if this is better now..But if you need plan for procedure -
"change it" to execute block and you got all statements plan regards,Karol
Bieniaszewski W dniu 2016-05-31 19:39:56 użytkownik Gabriel Frones
grfro...@gmail.com [firebird-support] <firebird-support@yahoogroups.com>
napisał:
It was sent and received... but this is working for me out of the box in FB
2.5.4. I just write the select * from SP and ask for plan and it gives me the
plan for the inside statements. Haven't tested on non-selectable SPs. Em qua,
25 de mai de 2016 às 08:20, João Paulo Carvalho joao_paul...@yahoo.com
[firebird-support] <firebird-support@yahoogroups.com> escreveu:
Hi. Since this was my first post in this list, I'm not sure if it was sent.
If you already get it, or this is not the right place to discuss this kind of
topic, I would be very grateful if you tell me where is. Att.João Paulo
DE: "joao_paul...@yahoo.com [firebird-support]"
<firebird-support@yahoogroups.com>
Para: firebird-support@yahoogroups.com
Enviadas: Sexta-feira, 20, Maio 2016 15:54:07
Assunto: [firebird-support] Stored Procedures Execution Plan
Hi. I would like to know if it is possible to display the plan of stored
procedure statements. I'm interested in the plan of the statements inside the
stored procedure (SP), not the plan just informing that I'm executing an SP. We
are running also selectable SP's. Att. João Paulo
#yiv7257244709 #yiv7257244709 -- #yiv7257244709ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7257244709
#yiv7257244709ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7257244709
#yiv7257244709ygrp-mkp #yiv7257244709hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7257244709 #yiv7257244709ygrp-mkp #yiv7257244709ads
{margin-bottom:10px;}#yiv7257244709 #yiv7257244709ygrp-mkp .yiv7257244709ad
{padding:0 0;}#yiv7257244709 #yiv7257244709ygrp-mkp .yiv7257244709ad p
{margin:0;}#yiv7257244709 #yiv7257244709ygrp-mkp .yiv7257244709ad a
{color:#0000ff;text-decoration:none;}#yiv7257244709 #yiv7257244709ygrp-sponsor
#yiv7257244709ygrp-lc {font-family:Arial;}#yiv7257244709
#yiv7257244709ygrp-sponsor #yiv7257244709ygrp-lc #yiv7257244709hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7257244709
#yiv7257244709ygrp-sponsor #yiv7257244709ygrp-lc .yiv7257244709ad
{margin-bottom:10px;padding:0 0;}#yiv7257244709 #yiv7257244709actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7257244709
#yiv7257244709activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7257244709
#yiv7257244709activity span {font-weight:700;}#yiv7257244709
#yiv7257244709activity span:first-child
{text-transform:uppercase;}#yiv7257244709 #yiv7257244709activity span a
{color:#5085b6;text-decoration:none;}#yiv7257244709 #yiv7257244709activity span
span {color:#ff7900;}#yiv7257244709 #yiv7257244709activity span
.yiv7257244709underline {text-decoration:underline;}#yiv7257244709
.yiv7257244709attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7257244709 .yiv7257244709attach div a
{text-decoration:none;}#yiv7257244709 .yiv7257244709attach img
{border:none;padding-right:5px;}#yiv7257244709 .yiv7257244709attach label
{display:block;margin-bottom:5px;}#yiv7257244709 .yiv7257244709attach label a
{text-decoration:none;}#yiv7257244709 blockquote {margin:0 0 0
4px;}#yiv7257244709 .yiv7257244709bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7257244709
.yiv7257244709bold a {text-decoration:none;}#yiv7257244709 dd.yiv7257244709last
p a {font-family:Verdana;font-weight:700;}#yiv7257244709 dd.yiv7257244709last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7257244709
dd.yiv7257244709last p span.yiv7257244709yshortcuts
{margin-right:0;}#yiv7257244709 div.yiv7257244709attach-table div div a
{text-decoration:none;}#yiv7257244709 div.yiv7257244709attach-table
{width:400px;}#yiv7257244709 div.yiv7257244709file-title a, #yiv7257244709
div.yiv7257244709file-title a:active, #yiv7257244709
div.yiv7257244709file-title a:hover, #yiv7257244709 div.yiv7257244709file-title
a:visited {text-decoration:none;}#yiv7257244709 div.yiv7257244709photo-title a,
#yiv7257244709 div.yiv7257244709photo-title a:active, #yiv7257244709
div.yiv7257244709photo-title a:hover, #yiv7257244709
div.yiv7257244709photo-title a:visited {text-decoration:none;}#yiv7257244709
div#yiv7257244709ygrp-mlmsg #yiv7257244709ygrp-msg p a
span.yiv7257244709yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7257244709
.yiv7257244709green {color:#628c2a;}#yiv7257244709 .yiv7257244709MsoNormal
{margin:0 0 0 0;}#yiv7257244709 o {font-size:0;}#yiv7257244709
#yiv7257244709photos div {float:left;width:72px;}#yiv7257244709
#yiv7257244709photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7257244709
#yiv7257244709photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7257244709
#yiv7257244709reco-category {font-size:77%;}#yiv7257244709
#yiv7257244709reco-desc {font-size:77%;}#yiv7257244709 .yiv7257244709replbq
{margin:4px;}#yiv7257244709 #yiv7257244709ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7257244709 #yiv7257244709ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7257244709
#yiv7257244709ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7257244709
#yiv7257244709ygrp-mlmsg select, #yiv7257244709 input, #yiv7257244709 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7257244709
#yiv7257244709ygrp-mlmsg pre, #yiv7257244709 code {font:115%
monospace;}#yiv7257244709 #yiv7257244709ygrp-mlmsg *
{line-height:1.22em;}#yiv7257244709 #yiv7257244709ygrp-mlmsg #yiv7257244709logo
{padding-bottom:10px;}#yiv7257244709 #yiv7257244709ygrp-msg p a
{font-family:Verdana;}#yiv7257244709 #yiv7257244709ygrp-msg
p#yiv7257244709attach-count span {color:#1E66AE;font-weight:700;}#yiv7257244709
#yiv7257244709ygrp-reco #yiv7257244709reco-head
{color:#ff7900;font-weight:700;}#yiv7257244709 #yiv7257244709ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7257244709 #yiv7257244709ygrp-sponsor
#yiv7257244709ov li a {font-size:130%;text-decoration:none;}#yiv7257244709
#yiv7257244709ygrp-sponsor #yiv7257244709ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7257244709
#yiv7257244709ygrp-sponsor #yiv7257244709ov ul {margin:0;padding:0 0 0
8px;}#yiv7257244709 #yiv7257244709ygrp-text
{font-family:Georgia;}#yiv7257244709 #yiv7257244709ygrp-text p {margin:0 0 1em
0;}#yiv7257244709 #yiv7257244709ygrp-text tt {font-size:120%;}#yiv7257244709
#yiv7257244709ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7257244709
