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
#yiv1927926194 #yiv1927926194 -- #yiv1927926194ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1927926194
#yiv1927926194ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1927926194
#yiv1927926194ygrp-mkp #yiv1927926194hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1927926194 #yiv1927926194ygrp-mkp #yiv1927926194ads
{margin-bottom:10px;}#yiv1927926194 #yiv1927926194ygrp-mkp .yiv1927926194ad
{padding:0 0;}#yiv1927926194 #yiv1927926194ygrp-mkp .yiv1927926194ad p
{margin:0;}#yiv1927926194 #yiv1927926194ygrp-mkp .yiv1927926194ad a
{color:#0000ff;text-decoration:none;}#yiv1927926194 #yiv1927926194ygrp-sponsor
#yiv1927926194ygrp-lc {font-family:Arial;}#yiv1927926194
#yiv1927926194ygrp-sponsor #yiv1927926194ygrp-lc #yiv1927926194hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1927926194
#yiv1927926194ygrp-sponsor #yiv1927926194ygrp-lc .yiv1927926194ad
{margin-bottom:10px;padding:0 0;}#yiv1927926194 #yiv1927926194actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1927926194
#yiv1927926194activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1927926194
#yiv1927926194activity span {font-weight:700;}#yiv1927926194
#yiv1927926194activity span:first-child
{text-transform:uppercase;}#yiv1927926194 #yiv1927926194activity span a
{color:#5085b6;text-decoration:none;}#yiv1927926194 #yiv1927926194activity span
span {color:#ff7900;}#yiv1927926194 #yiv1927926194activity span
.yiv1927926194underline {text-decoration:underline;}#yiv1927926194
.yiv1927926194attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1927926194 .yiv1927926194attach div a
{text-decoration:none;}#yiv1927926194 .yiv1927926194attach img
{border:none;padding-right:5px;}#yiv1927926194 .yiv1927926194attach label
{display:block;margin-bottom:5px;}#yiv1927926194 .yiv1927926194attach label a
{text-decoration:none;}#yiv1927926194 blockquote {margin:0 0 0
4px;}#yiv1927926194 .yiv1927926194bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1927926194
.yiv1927926194bold a {text-decoration:none;}#yiv1927926194 dd.yiv1927926194last
p a {font-family:Verdana;font-weight:700;}#yiv1927926194 dd.yiv1927926194last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1927926194
dd.yiv1927926194last p span.yiv1927926194yshortcuts
{margin-right:0;}#yiv1927926194 div.yiv1927926194attach-table div div a
{text-decoration:none;}#yiv1927926194 div.yiv1927926194attach-table
{width:400px;}#yiv1927926194 div.yiv1927926194file-title a, #yiv1927926194
div.yiv1927926194file-title a:active, #yiv1927926194
div.yiv1927926194file-title a:hover, #yiv1927926194 div.yiv1927926194file-title
a:visited {text-decoration:none;}#yiv1927926194 div.yiv1927926194photo-title a,
#yiv1927926194 div.yiv1927926194photo-title a:active, #yiv1927926194
div.yiv1927926194photo-title a:hover, #yiv1927926194
div.yiv1927926194photo-title a:visited {text-decoration:none;}#yiv1927926194
div#yiv1927926194ygrp-mlmsg #yiv1927926194ygrp-msg p a
span.yiv1927926194yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1927926194
.yiv1927926194green {color:#628c2a;}#yiv1927926194 .yiv1927926194MsoNormal
{margin:0 0 0 0;}#yiv1927926194 o {font-size:0;}#yiv1927926194
#yiv1927926194photos div {float:left;width:72px;}#yiv1927926194
#yiv1927926194photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1927926194
#yiv1927926194photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1927926194
#yiv1927926194reco-category {font-size:77%;}#yiv1927926194
#yiv1927926194reco-desc {font-size:77%;}#yiv1927926194 .yiv1927926194replbq
{margin:4px;}#yiv1927926194 #yiv1927926194ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1927926194 #yiv1927926194ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1927926194
#yiv1927926194ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1927926194
#yiv1927926194ygrp-mlmsg select, #yiv1927926194 input, #yiv1927926194 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1927926194
#yiv1927926194ygrp-mlmsg pre, #yiv1927926194 code {font:115%
monospace;}#yiv1927926194 #yiv1927926194ygrp-mlmsg *
{line-height:1.22em;}#yiv1927926194 #yiv1927926194ygrp-mlmsg #yiv1927926194logo
{padding-bottom:10px;}#yiv1927926194 #yiv1927926194ygrp-msg p a
{font-family:Verdana;}#yiv1927926194 #yiv1927926194ygrp-msg
p#yiv1927926194attach-count span {color:#1E66AE;font-weight:700;}#yiv1927926194
#yiv1927926194ygrp-reco #yiv1927926194reco-head
{color:#ff7900;font-weight:700;}#yiv1927926194 #yiv1927926194ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1927926194 #yiv1927926194ygrp-sponsor
#yiv1927926194ov li a {font-size:130%;text-decoration:none;}#yiv1927926194
#yiv1927926194ygrp-sponsor #yiv1927926194ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1927926194
#yiv1927926194ygrp-sponsor #yiv1927926194ov ul {margin:0;padding:0 0 0
8px;}#yiv1927926194 #yiv1927926194ygrp-text
{font-family:Georgia;}#yiv1927926194 #yiv1927926194ygrp-text p {margin:0 0 1em
0;}#yiv1927926194 #yiv1927926194ygrp-text tt {font-size:120%;}#yiv1927926194
#yiv1927926194ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1927926194
