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 "Mamta A. Satoor (JIRA)" <de...@db.apache.org> on 2006/10/16 18:50:34 UTC
[jira] Created: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
-------------------------------------------------------------------------------------------------------------
Key: DERBY-1964
URL: http://issues.apache.org/jira/browse/DERBY-1964
Project: Derby
Issue Type: Improvement
Components: Documentation
Affects Versions: 10.3.0.0
Reporter: Mamta A. Satoor
Priority: Minor
As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12501960 ]
Laura Stewart commented on DERBY-1964:
--------------------------------------
Committed revision 544867.
> Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1964
> URL: https://issues.apache.org/jira/browse/DERBY-1964
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assignee: Laura Stewart
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: cadminspace21579.html, ctunstats57373.html, ctunstats57373.html, ctunstats57373.html, derby1964_1.diff, derby1964_2.diff, derby1964_3.diff, derby1964_4.diff, rrefaltertablecompress.html, rrefaltertablecompress.html, rrefproceduresinplacecompress.html
>
>
> As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-1964:
---------------------------------
Attachment: derby1964_3.diff
ctunstats57373.html
Updated the ctunstats57373.html file per Mike's comments.
Also attaching an updated diff file = derby1964_3.diff
> Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1964
> URL: https://issues.apache.org/jira/browse/DERBY-1964
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assignee: Laura Stewart
> Priority: Minor
> Attachments: cadminspace21579.html, ctunstats57373.html, ctunstats57373.html, ctunstats57373.html, derby1964_1.diff, derby1964_2.diff, derby1964_3.diff, rrefaltertablecompress.html, rrefaltertablecompress.html, rrefproceduresinplacecompress.html
>
>
> As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-1964:
---------------------------------
Attachment: cadminspace21579.html
rrefproceduresinplacecompress.html
rrefaltertablecompress.html
The main file updated is rrefaltertablecompress.html.
Very minor updates were made to the following files. These updates such as typos or adding indexes)
are unrelated to the issue but needed to be corrected:
- cadminspace21579.html
- rrefproceduresinplacecompress.html
- ctunstats57373.html
> Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1964
> URL: https://issues.apache.org/jira/browse/DERBY-1964
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assigned To: Laura Stewart
> Priority: Minor
> Attachments: cadminspace21579.html, derby1964_1.diff, rrefaltertablecompress.html, rrefproceduresinplacecompress.html
>
>
> As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali updated DERBY-1964:
----------------------------------
how about just changing backing indexes to newly created indexes.
The concept is that for the operations mentioned Derby may create "internal" indexes to support the operation.
For instance when you add a unique constraint, Derby will first check if there are any existing indexes that already guarantee that
unique constraint, if so no index is added (and no update of statistics), but if no index exists then a new internal index is
generated with a system generated name that enforces uniqueness when a row is inserted.
> Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1964
> URL: https://issues.apache.org/jira/browse/DERBY-1964
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assignee: Laura Stewart
> Priority: Minor
> Attachments: cadminspace21579.html, ctunstats57373.html, ctunstats57373.html, derby1964_1.diff, derby1964_2.diff, rrefaltertablecompress.html, rrefaltertablecompress.html, rrefproceduresinplacecompress.html
>
>
> As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart reassigned DERBY-1964:
------------------------------------
Assignee: Laura Stewart
> Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1964
> URL: https://issues.apache.org/jira/browse/DERBY-1964
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assigned To: Laura Stewart
> Priority: Minor
>
> As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali updated DERBY-1964:
----------------------------------
Instead of:
The SYSCS_UTIL.SYSCS_COMPRESS_TABLE system procedure creates statistics for indexes if the statistics do not already exist.
something like:
The SYSCS_UTIL.SYSCS_COMPRESS_TABLE system procedure will update statistics on all indexes as
part of the index rebuilding process.
The reality is that we create a new statistic if no statistic existed, and we update existing statistics with
current full information if they already existed. But I am not sure the documentation need say that.
> Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1964
> URL: https://issues.apache.org/jira/browse/DERBY-1964
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assigned To: Laura Stewart
> Priority: Minor
> Attachments: cadminspace21579.html, ctunstats57373.html, derby1964_1.diff, rrefaltertablecompress.html, rrefproceduresinplacecompress.html
>
>
> As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart resolved DERBY-1964.
----------------------------------
Resolution: Fixed
Issue completed for 10.3
> Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1964
> URL: https://issues.apache.org/jira/browse/DERBY-1964
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assignee: Laura Stewart
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: cadminspace21579.html, ctunstats57373.html, ctunstats57373.html, ctunstats57373.html, derby1964_1.diff, derby1964_2.diff, derby1964_3.diff, derby1964_4.diff, rrefaltertablecompress.html, rrefaltertablecompress.html, rrefproceduresinplacecompress.html
>
>
> As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-1964:
---------------------------------
Attachment: ctunstats57373.html
Another substantive change was made to the file
ctunstats57373.html
> Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1964
> URL: https://issues.apache.org/jira/browse/DERBY-1964
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assigned To: Laura Stewart
> Priority: Minor
> Attachments: cadminspace21579.html, ctunstats57373.html, derby1964_1.diff, rrefaltertablecompress.html, rrefproceduresinplacecompress.html
>
>
> As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren updated DERBY-1964:
--------------------------------------
Fix Version/s: 10.3.0.0
looks like this should be possible for 10.3
> Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1964
> URL: https://issues.apache.org/jira/browse/DERBY-1964
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assignee: Laura Stewart
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: cadminspace21579.html, ctunstats57373.html, ctunstats57373.html, ctunstats57373.html, derby1964_1.diff, derby1964_2.diff, derby1964_3.diff, rrefaltertablecompress.html, rrefaltertablecompress.html, rrefproceduresinplacecompress.html
>
>
> As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali updated DERBY-1964:
----------------------------------
Instead of:
When cardinality statistics are automatically updated
For the following operations that you perform on a table, Derby automatically creates statistics. Those operations are:
(new index only) When you create a new index on an existing non-empty table.
(new backing indexes only) When you add a primary key, unique, or foreign key constraint to an existing non-empty table.
(all indexes) When you run the SYSCS_UTIL.SYSCS_COMPRESS_TABLE system procedure. Statistics are created if they do not already exist.
For other operations, Derby automatically updates statistics for the table and all indexes on the table if they are already exist. Those operations are:
(all indexes) When you run the SYSCS_UTIL.SYSCS_COMPRESS_TABLE system procedure.
(index only) When you drop a column that is part of a table's index; the statistics for the affected index are dropped, and statistics for the other indexes on the table are updated.
Something like:
When cardinality statistics are automatically updated
For the following operations that you perform on a table, Derby automatically either creates new statistics or updates existing statistics. Those operations are:
(new index only) When you create a new index on an existing non-empty table.
(new backing indexes only) When you add a primary key, unique, or foreign key constraint to an existing non-empty table.
(all indexes) When you run the SYSCS_UTIL.SYSCS_COMPRESS_TABLE system procedure. Statistics are created if they do not already exist.
(index only) When you drop a column that is part of a table's index; the statistics for the affected index are dropped, and statistics for the other indexes on the table are updated.
> Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1964
> URL: https://issues.apache.org/jira/browse/DERBY-1964
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assigned To: Laura Stewart
> Priority: Minor
> Attachments: cadminspace21579.html, ctunstats57373.html, derby1964_1.diff, rrefaltertablecompress.html, rrefproceduresinplacecompress.html
>
>
> As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Posted by "Mike Matrigali (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mike Matrigali updated DERBY-1964:
----------------------------------
most recent changes look fine to me.
> Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1964
> URL: https://issues.apache.org/jira/browse/DERBY-1964
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assignee: Laura Stewart
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: cadminspace21579.html, ctunstats57373.html, ctunstats57373.html, ctunstats57373.html, derby1964_1.diff, derby1964_2.diff, derby1964_3.diff, rrefaltertablecompress.html, rrefaltertablecompress.html, rrefproceduresinplacecompress.html
>
>
> As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12498361 ]
Laura Stewart commented on DERBY-1964:
--------------------------------------
Please review these files for this issue:
rrefaltertablecompress.html
ctunstats57373.html
> Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1964
> URL: https://issues.apache.org/jira/browse/DERBY-1964
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assigned To: Laura Stewart
> Priority: Minor
> Attachments: cadminspace21579.html, ctunstats57373.html, derby1964_1.diff, rrefaltertablecompress.html, rrefproceduresinplacecompress.html
>
>
> As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-1964:
---------------------------------
Attachment: derby1964_1.diff
Attaching the patch file
derby1964_1.diff
> Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1964
> URL: https://issues.apache.org/jira/browse/DERBY-1964
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assigned To: Laura Stewart
> Priority: Minor
> Attachments: derby1964_1.diff
>
>
> As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-1964:
---------------------------------
Attachment: derby1964_4.diff
> Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1964
> URL: https://issues.apache.org/jira/browse/DERBY-1964
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assignee: Laura Stewart
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: cadminspace21579.html, ctunstats57373.html, ctunstats57373.html, ctunstats57373.html, derby1964_1.diff, derby1964_2.diff, derby1964_3.diff, derby1964_4.diff, rrefaltertablecompress.html, rrefaltertablecompress.html, rrefproceduresinplacecompress.html
>
>
> As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-1964) Update the documentation of
SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of
DERBY-737
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-1964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-1964:
---------------------------------
Attachment: ctunstats57373.html
rrefaltertablecompress.html
derby1964_2.diff
Updated the files per comments from Mike.
I restructured the list in ctunstats57373.html. I did not think that
the text in the beginning parenthesis was helpful. I moved that info to
a separate sentence at the end of each bullet.
One question - what is a "backing index" I don't think that term is clear.
Can we reword it?
The updated files are:
ctunstats57373.html
rrefaltertablecompress.html
> Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737
> -------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1964
> URL: https://issues.apache.org/jira/browse/DERBY-1964
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Mamta A. Satoor
> Assignee: Laura Stewart
> Priority: Minor
> Attachments: cadminspace21579.html, ctunstats57373.html, ctunstats57373.html, derby1964_1.diff, derby1964_2.diff, rrefaltertablecompress.html, rrefaltertablecompress.html, rrefproceduresinplacecompress.html
>
>
> As part of DERBY-737 "SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist", SYSCS_UTIL.SYSCS_COMPRESS_TABLE now will create statistics for indexes if they do not already exist. This needs to be documented. The changes went into 10.3 codeline when I created this documentation jira entry. The changes may get ported to prior releases. Please check DERBY-737 to see what all releases will need the documentation changes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.