Salesforce

Is it necessary to rebuild global indexes after loading the data into a partitioned table?

« Go Back

Information

 
TitleIs it necessary to rebuild global indexes after loading the data into a partitioned table?
URL NameIs-it-necessary-to-rebuild-global-indexes-after-loading-the-data-into-a-partitioned-table
Article Number000115523
EnvironmentProduct: OpenEdge
Version: All supported versions
OS: All supported platforms
Other: Table partitioning.
Question/Problem Description
Is it necessary to rebuild global indexes after loading the data using Data Dictionary or PROUTIL LOAD into a partitioned table?
Is it necessary to rebuild global indexes after loading the data into a partitioned table, as TPIDXBUILD only build local indexes ?
Is it necessary to rebuild global indexes after loading the data into a partitioned table?
 
Steps to Reproduce
Clarifying Information
TPIDXBUILD  is used to build the local indexes only.

 
Error Message
Defect Number
Enhancement Number
Cause
Resolution
When Data Dictionary or PROUTIL LOAD is used to load data into a partitioned table, then there is no need to rebuild the global indexes, because the global indexes are updated automatically during the load. 

When performing Binary load and index rebuild simultaneously if "partition" or "composite initial" is not specified in the command then global indexes are build along with the local indexes. 
In this case Global indexes are deactivate first and then rebuilt, because they are already active and an active index cannot be reactivated.
It will first need to be deactivated.

If  "partition" or "composite initial" is specified in the command then, it will just rebuild the Local Indexes as Global indexes are automatically updated during the load.

$ proutil db-name -C load filename [partition partition-name| composite initial] [ build indexes] [ -dumplist dumpfile ]


 
Workaround
Notes
References to Other Documentation:
Database Administration: PROUTIL Utility : PROUTIL LOAD qualifier
Database Administration: PROUTIL Utility : PROUTIL TPIDXBUILD qualifier

Progress Article(s):
 Building Indexes with Binary Load
​ Binary load and index build simultaneously on Table partitioning enabled database fails with timeout error(8812) when the amount of data is high.
 Is it required to run IDXACTIVATE when adding an index to an existing table when the database is offline?
Keyword Phrase
Last Modified Date11/20/2020 7:11 AM

Powered by