db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] Assigned: (DERBY-2617) automatically generate statistics info when indexes are recreated as part of an alter table action
Date Sun, 06 May 2007 22:19:15 GMT

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

Mike Matrigali reassigned DERBY-2617:
-------------------------------------

    Assignee: Mike Matrigali

> automatically generate statistics info when indexes are recreated as part of an alter
table action
> --------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2617
>                 URL: https://issues.apache.org/jira/browse/DERBY-2617
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.0.2.2, 10.1.3.2, 10.1.4.0, 10.2.2.1, 10.2.3.0, 10.3.0.0
>            Reporter: Mike Matrigali
>         Assigned To: Mike Matrigali
>            Priority: Minor
>
> Currently statistics are only generated as part of recreating indexes in an alter table
action if they already exist.  Similar 
> to DERBY-737 derby should go ahead and create the statistics whether they already exist
or not.  The work is almost free as we are already doing the sort and create of the index,
so no reason to not generate them at this point.
> See updateIndex() code in AlterTableConstantAction.java.

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