db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4758) Adding documentation about the PlanExporter Tool
Date Mon, 09 Aug 2010 15:45:16 GMT

    [ 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.


Mime
View raw message