Issue Details (XML | Word | Printable)

Key: CORE-3332
Type: New Feature New Feature
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Provide more detailed information about the query execution plan

Created: 02/Feb/11 11:28 AM   Updated: 28/Jan/20 06:06 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 3.0 Alpha 1

Issue Links:
Depend
 

QA Status: Covered by another test(s)
Test Details:
See tests for COREs: 4498 4318 5236 5070 5598 6218 et al. All of them use explained plan in expected* sections.


 Description  « Hide
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.


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
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?

Dmitry Yemanov added a comment - 02/Feb/14 12:26 PM
It will be available in Beta 1.