[DERBY-4115] Provide a way to drop statistics information

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.6.1.0
• Fix Version/s: 10.9.1.0
• Component/s: SQL
• Labels: derby_backport_reject_10_8
• Issue & fix info: High Value Fix
• Assignee: Mamta A. Satoor
• Reporter: Katherine Marsden
• Created: 24/Mar/09 19:03
• Updated: 17/Jun/13 09:19
• Resolved: 22/May/12 03:24

Description

Now that DERBY-269 has been resolved, users can update statistics, but once they do, they are committed to using and maintaining the statistics, even if it doesn't improve performance or they have difficulty maintaining the statistics on a regular basis. It would be good to have a way to drop statistics information so that users could revert to the prior behavior if needed.

Issue Links

• is related to: DERBY-5681 When a foreign key constraint on a table is dropped, the associated statistics row for the conglomerate is not removed
• is related to: DERBY-269 Provide some way to update index cardinality statistics (e.g. reimplement update statistics)

Sub-Tasks

• Document new SYSCS_DROP_STATISTICS procedure: Closed