When you add an index to a table, create index is recorded in the transaction log. As it fills the index pages with information, however, Adaptive Server does not log the changes.
If your database device fails after you create an index, load transaction may take as long to reconstruct the index as create index took to build it. To avoid lengthy delays, dump each database immediately after creating an index on one of its tables.
