$G_REBUILD_INDEXES use in Rapid Mart

dataservices rapidmarts
1

Hi,

Can someone share more info on how to use the sample Create_Sample_Maintenance_SP.sql mentioned in the rapid mart user guide for rebuilding the index. We have global variable $G_REBUILD_INDEXES which could be set to a y or n in order to rebuild the index. Is the global variable value -Y/N specific to delta or full run? I mean it has to be a Y for a full run and no for delta or like wise?

Thanks[/quote]

arjunria25 (BOB member since 2011-09-30)

2

It is common during large data loads, such as initial loads or loading large source tables, to relax all non-primary key indices on the target table(s).

The thought is that you will re-build the indices after the large data load versus having the DB update the index in tandem with the insert statement.

Which target DB are you using? Are you also considering using the Bulk Loader capabilities?

SalH :mexico: (BOB member since 2010-11-09)