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] Created: (DERBY-2617) automatically generate statistics info when indexes are recreated as part of an alter table action
Date Sun, 06 May 2007 15:56:15 GMT
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.


Mime
View raw message