Question area truncate and orphan index records

danishgambit · Jul 22, 2014

Version 10.2b on RHL.

Afternoon,

hoping for some advice. If I truncate an area, as a way of "fast-deleting" the records in that area, what happens to the index records for these tables which live in another area. I know they're marked as inactive as part of the area truncate process , and I assume that a subsequent index rebuild then removes these orphaned index records, but was hoping someone might be able to confirm that this is the case (if it is).

Thanks in advance,

DG.

Rob Fitzpatrick · Jul 22, 2014

Idxbuild doesn't remove index keys from existing indexes. It reformats index blocks and recreates the indexes from scratch based on the record data in the table(s). This will run very quickly when the table in question is empty.

If you are doing this in a database where you care at all about the data (e.g. prod), be very careful about this approach. Make sure you know exactly which objects (tables, indexes, LOBs) are in this area. If done incorrectly this could be, as Progress says, a career-altering decision. Note also that truncate area requires a BI truncation.

danishgambit · Jul 22, 2014

Rob Fitzpatrick said:
Idxbuild doesn't remove index keys from existing indexes. It reformats index blocks and recreates the indexes from scratch based on the record data in the table(s). This will run very quickly when the table in question is empty.

If you are doing this in a database where you care at all about the data (e.g. prod), be very careful about this approach. Make sure you know exactly which objects (tables, indexes, LOBs) are in this area. If done incorrectly this could be, as Progress says, a career-altering decision. Note also that truncate area requires a BI truncation.

danishgambit · Jul 22, 2014

thanks for that Rob. Yes, i've checked and double-checked and we're comfortable with using this utility on this particular area.

Cheers,

DG.

Question area truncate and orphan index records

danishgambit

Member

Rob Fitzpatrick

ProgressTalk.com Sponsor

danishgambit

Member

danishgambit

Member

Similar threads