[jira] Updated: (DERBY-3259) Tuning manual needs performance tip on compressing tables

["Bryan Pendleton (JIRA)" <ji...@apache.org>]

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

Bryan Pendleton updated DERBY-3259:
-----------------------------------

    Attachment: ctunstats849505.html
                ctunperf25864.html
                ctunperfstatistics.html

Attached is a proposed docs patch, and HTML formatted versions of
the 3 modified files: "The Tips", "Ensure table statistics are accurate",
and "When cardinality statistics go stale".

I think that the information elsewhere in the tuning and ref guides is
pretty complete; I think this new 'tips' page basically serves to alert
users to this potential situation and to direct their attention to the
relevant documentation.

Please let me know what you think of the changes.


> Tuning manual needs performance tip on compressing tables
> ---------------------------------------------------------
>
>                 Key: DERBY-3259
>                 URL: https://issues.apache.org/jira/browse/DERBY-3259
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.3.1.4
>            Reporter: Kim Haase
>            Assignee: Bryan Pendleton
>         Attachments: ctunperf25864.html, ctunperfstatistics.html, ctunstats849505.html, docs.diff
>
>
> The "Performance Tips and Tricks" section of the Tuning Derby manual needs a topic that recommends the use of the SYSCS_UTIL.SYSCS_COMPRESS_TABLE procedure to resolve performance problems having to do with indexes and complex table joins. (Please rephrase this if I haven't put it correctly.)
> For details, see the discussion at http://www.nabble.com/Re%3A-FW%3A-Advice-on-*very*-badly-performing-query-tf4939807.html.

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