Re: Re: [firebird-support] Stored Procedures Execution Plan

Wed, 01 Jun 2016 03:28:01 -0700 

Hi,
 
yes but this was "wrong"
Consider this:
inside procedure you have 5 different statements
and 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 [email protected] 
[firebird-support] <[email protected]> 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 [email protected] 
[firebird-support] <[email protected]> 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: "[email protected] [firebird-support]" 
<[email protected]>
Para: [email protected]
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
 
 
 

 

Reply via email to