db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2487) Enhance Derby with EXPLAIN Functionality
Date Mon, 30 Mar 2009 04:02:50 GMT

     [ https://issues.apache.org/jira/browse/DERBY-2487?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Bryan Pendleton updated DERBY-2487:
-----------------------------------

    Attachment: userSchemaPrototyping.diff

Attached 'userSchemaPrototyping.diff' is a substantially modified patch. I've been
working on prototyping a new approach, placing the XPLAIN tables into a user schema.

This patch is not ready; it barely compiles, and definitely doesn't work. But I've
done a lot of investigation into the new approach, and wanted to post the patch
to keep the work on the community's radar.

The new code:
- renames the system procedures to SET_XPLAIN_SCHEMA and GET_XPLAIN_SCHEMA.
- SET_XPLAIN_SCHEMA now takes a schema name, and creates that schema if
it doesn't yet exist.
- then the system procedure creates the six XPLAIN tables in that schema.

I still need to do the work so that the captured XPLAIN data is stored into those tables.

Plus there's an enormous amount of error-handling, testing, and clean up that will need to
be done.

But I'm pleased with the progress so far, and felt it was worthy of posting.

> Enhance Derby with EXPLAIN Functionality
> ----------------------------------------
>
>                 Key: DERBY-2487
>                 URL: https://issues.apache.org/jira/browse/DERBY-2487
>             Project: Derby
>          Issue Type: New Feature
>          Components: SQL
>    Affects Versions: 10.2.2.0
>            Reporter: Felix Beyer
>            Assignee: Bryan Pendleton
>            Priority: Minor
>         Attachments: Derby physical XPLAIN schema.png, incorporateTrunkChanges.diff,
removeSourceDepth.diff, RSProtocolNew.pdf, rts.xls, small logical xplain schema.pdf, startRegressionTest.diff,
startRegressionTest.diff, startUpgradeTests.diff, updateRegressionTests.diff, updateRegressionTests.diff,
usage.txt, userSchemaPrototyping.diff, xplain_patch_v1.txt, xplainClasses.pdf
>
>
> This enhancement extends Derby with EXPLAIN functions. Users want to have more feedback
than they`re getting with the current RuntimeStatistics facility. This extension is based
on the RuntimeStatistics/ResultSetStatistics functions / classes. 

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