[ 
https://issues.apache.org/jira/browse/DERBY-4758?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12896593#action_12896593
 ] 

Kim Haase commented on DERBY-4758:
----------------------------------

A few questions on the PlanExporter XML Format topic:

In some cases it's clear what row of a SYSXPLAIN table the topic is referring 
to, but in others it is not.

"The statement element ... This element has only its value. That value implies 
the query executed as mentioned in SYSXPLAIN_STATEMENTS table."

Is this the value from the STMT_TEXT row of the SYSXPLAIN_STATEMENTS table?

The attributes of the node element sometimes have the same name as the 
corresponding row of the SYSXPLAIN table, but in some cases they don't, so I 
want to make sure I know the right one:

visited_pages, from SYSXPLAIN_SCAN_PROPS -- is this NO_VISITED_PAGES?

scanned_object, from SYSXPLAIN_SCAN_PROPS -- is this SCAN_OBJECT_NAME?

scan_type, from SYSXPLAIN_SCAN_PROPS -- is this SCAN_OBJECT_TYPE?

sorter_output, from SYSXPLAIN_SORT_PROPS -- I can't tell what row this might 
refer to at all.

I'm thinking this bullet list should be a two-column table -- I'll work on that.


> Adding documentation about the PlanExporter Tool
> ------------------------------------------------
>
>                 Key: DERBY-4758
>                 URL: https://issues.apache.org/jira/browse/DERBY-4758
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Documentation
>            Reporter: C.S. Nirmal J. Fernando
>            Assignee: C.S. Nirmal J. Fernando
>            Priority: Critical
>         Attachments: DERBY-4758-2.zip, DERBY-4758.zip, derby4758-2.diff, 
> derby4758.diff
>
>
> Providing a user guide documentation in 
> http://db.apache.org/derby/docs/10.6/tools/

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to