The new information tag (isc_info_sql_explain_plan) can be used to retrieve the detailed textual output. Please note that it's still limited to 64KB, due to the API restrictions, so the output could be truncated. An unlimited version of the text would be available via the MON$STATEMENTS table.
Description
Details could be found here: http://sourceforge.net/mailarchive/message.php?msg_id=24546633
The new information tag (isc_info_sql_explain_plan) can be used to retrieve the detailed textual output. Please note that it's still limited to 64KB, due to the API restrictions, so the output could be truncated. An unlimited version of the text would be available via the MON$STATEMENTS table.
I see the first part of this new feature is implemented in 3.0 alpha 1 (and ISQL), but what about the second part of this request, i.e. adding an unlimited version of the plan text in the MON$STATEMENTS table. I don't see an additional column in MON$STATEMENTS, also not in alpha 2.
Is this still pending to be implemented?
Robert added a comment - 02/Feb/14 12:14 PM I see the first part of this new feature is implemented in 3.0 alpha 1 (and ISQL), but what about the second part of this request, i.e. adding an unlimited version of the plan text in the MON$STATEMENTS table. I don't see an additional column in MON$STATEMENTS, also not in alpha 2.
Is this still pending to be implemented?
New Feature
Closed
Major
Provide more detailed information about the query execution plan
Is this still pending to be implemented?