You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Mike Matrigali (JIRA)" <ji...@apache.org> on 2007/05/06 17:56:15 UTC
[jira] Created: (DERBY-2617) automatically generate statistics info
when indexes are recreated as part of an alter table action
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
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.
[jira] Resolved: (DERBY-2617) automatically generate statistics
info when indexes are recreated as part of an alter table action
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali resolved DERBY-2617.
-----------------------------------
Resolution: Invalid
I was confused by comments in the file, comments made it seem like only compress table was handled - but same code is used
by all alter table actions that require rebuild of index. I';ll update the comments as part of the work I am doing on AlterTableConstantAction.
> 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.
[jira] Closed: (DERBY-2617) automatically generate statistics info
when indexes are recreated as part of an alter table action
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali closed DERBY-2617.
---------------------------------
> 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.
[jira] Assigned: (DERBY-2617) automatically generate statistics
info when indexes are recreated as part of an alter table action
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ 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.