Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <5684802.259381290520694163.JavaMail.jira@thor>
Date: Tue, 23 Nov 2010 08:58:14 -0500 (EST)
From: "Kristian Waagan (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-4771) Continue investigation of automatic
 creation/update of index statistics
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Kristian Waagan updated DERBY-4771:
-----------------------------------

    Attachment: autoindexstats.html
                derby-4771-2e-prototype_lcc_code_dump.diff

Attached patch 2e, which contains the following changes:
 o removed tracing code from BTreeScan (included by mistake)
 o renamed value of trace-property from "dblog" to "log" (derby.storage.indexStats.trace=off|log|stdout|both)
 o introduced interface iapi...IndexStatisticsDaemon, renamed existing class to impl...IndexStatisticsDaemonImpl

Also attached a small HTML-file, 'autoindexstats.html', which describes some preliminary ideas for what can be done for later revisions of the feature. Feel free to add stuff if you have more ideas. We should also document a decision about not implementing any of these :) For instance, how many knobs do we want to expose for power-users? Another reason may be too high complexity.

Patch 2e ready for review.
I'd really like some review before committing this code, but if I nothing happens I will just commit it and handle the problems as they come :)

> Continue investigation of automatic creation/update of index statistics
> -----------------------------------------------------------------------
>
>                 Key: DERBY-4771
>                 URL: https://issues.apache.org/jira/browse/DERBY-4771
>             Project: Derby
>          Issue Type: Task
>          Components: SQL, Store
>    Affects Versions: 10.8.0.0
>            Reporter: Kristian Waagan
>            Assignee: Kristian Waagan
>         Attachments: autoindexstats.html, derby-4771-1a-prototype_code_dump.diff, derby-4771-1a-prototype_code_dump.stat, derby-4771-1b-prototype_code_dump.diff, derby-4771-2a-prototype_lcc_code_dump.diff, derby-4771-2b-prototype_lcc_code_dump.diff, derby-4771-2c-prototype_lcc_code_dump.diff, derby-4771-2d-prototype_lcc_code_dump.diff, derby-4771-2e-prototype_lcc_code_dump.diff, derby.log, error-stacktrace.out, rjall.out, rjall.out, rjall.out, rjall.rar, rjone.out
>
>
> Work was started to improve Derby's handling of index statistics. This issue tracks further discussion and work for this task.

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