Salesforce

IDXCOMPACT to only empty the index delete chains after mass purge on records with unique indexes

Printable View
« Go Back

Information

 
TitleIDXCOMPACT to only empty the index delete chains after mass purge on records with unique indexes
URL NameIDXCOMPACT-to-only-empty-the-index-delete-chains-after-mass-purge-on-records-with-unique-indexes
Article Number000205528
EnvironmentProduct: OpenEdge
Version: 11.7.11, 12.2.7, 12.5 and later
OS: All supported platforms
Other: IDXCOMPACT
Question/Problem Description

Can we specify the degree of index compaction below 50 to empty delete chains in the first phase and negate the overhead of the second phase?

Could we could use 'proutil -C idxcompact 0' to empty the index delete chains, when the entire table (or x millions wiping branches of unique indexes) has been deleted.

Is there an index utility to only empty the index delete chains without scanning the tree?

Can IDXCOMPACT below 50% or 0% be used in the improved 11.7.11, 12.2.7, 12.5 algorithm?

 

Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
12.5, 12.2.7, 11.7.11 enhanced the IDXCOMPACT algorithm so that deleted index blocks are more efficiently removed from the tree in a run [ OCTA-37121 ] IDXCOMPACT will still run both phases:

First phase: idxcompact scans the index delete chain and moves these blocks to the free chain when possible.
  • The degree of index compaction is not used at this phase.
  • BI notes are small as only the information in block header is changing, where idxcompact creates a separate transaction for each block on the index delete chain
Second phase: idxcompact scans the remaining blocks of the index tree.
  • The degree of index compaction % is used here.
  • BI notes are larger, in one transaction.
Negating the overhead of the second phase, for IDXCOMPACT on unique indexes to clear the index delete chain is not part of this improvement.

An enhancement request has been submitted as an Idea on the Progress Community. To promote the Idea, click on this link: https://openedge.ideas.aha.io/ideas/OPENEDGE-I-953  

Customer feedback is valuable and Idea submissions are monitored by our Product Management team. Enhancement requests are reviewed during the planning phase of each new product release and a list of the enhancements chosen for implementation can be found in the Release Notes documents that accompany each release. Once an Idea is submitted the Progress Software Community will have the opportunity to comment on and vote for the Idea. It's priority will be evaluated as customer demand weighs in through Article Feedback and through vote count in the Ideas Portal




 
Workaround
Notes
Keyword Phrase
Last Modified Date10/6/2021 8:55 AM
Powered by