achieve this?
Thanks,
Robert
-Original message/Oorspronkelijk bericht-
From: Dmitry Yemanov
Sent: Saturday, March 14, 2015 1:53 PM
To: For discussion among Firebird Developers
Subject: Re: [Firebird-devel] Retrieving plan using new mon$explained_plan
field (FB3 beta )
14.03.2015 15:38
18.03.2015 22:37, Robbert-Jan wrote:
If I execute this scenario (using FlameRobin and WI-T3.0.0.31369 Firebird
3.0 Beta 1):
- start transaction
- execute query 1: SELECT * FROM Table1
- execute query 2: SELECT * FROM Table2
- execute query 3: SELECT * FROM Table3
- execute query 4: SELECT
bericht-
From: Dmitry Yemanov
Sent: Wednesday, March 18, 2015 8:53 PM
To: For discussion among Firebird Developers
Subject: Re: [Firebird-devel] Retrieving plan using new mon$explained_plan
field (FB3 beta )
18.03.2015 22:37, Robbert-Jan wrote:
If I execute this scenario (using FlameRobin
Hi,
I’m trying to retrieve the explain plan of the last prepared query, using the
mon$explained_plan field, introduced in FB3 beta.
I used:
SELECT mon$explained_plan FROM mon$statements WHERE mon$transaction_id =
CURRENT_TRANSACTION
This seems to give me however the plan of the first prepared
14.03.2015 15:38, Robbert-Jan wrote:
I’m trying to retrieve the explain plan of the last prepared query,
using the mon$explained_plan field, introduced in FB3 beta.
I used:
SELECT mon$explained_plan FROM mon$statements WHERE mon$transaction_id =
CURRENT_TRANSACTION
Wrong. You should use