Hi, you must convert any procedure - for which you need plan - to execute block format
if you are interested in plan for proc 1 then you need proc 1 execte block if this proc1 use proc2 you need to make proc2 as execute block.. regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Wednesday, June 1, 2016 2:27 PM To: firebird-support@yahoogroups.com Subject: Re: Re: [firebird-support] Stored Procedures Execution Plan 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 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 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
