Archives of the TeradataForum
Message Posted: Fri, 06 Jun 2003 @ 10:41:46 GMT
I notice from the manuals that if you specify the INDEXES keyword in an archive script, that secondary index subtables are archived on the tape. I assume that this increases the time that the archive will take.
However, if you use arcmain without the indexes keyword, to archive data, the indexes are rebuilt anyway when you copy the data back.
In that case, why should anyone use the indexes keyword in their archive script? Is recovery quicker if you specify it?
Any advice or comments would be welcome.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|