Skip to Content
0
Former Member
Dec 08, 2011 at 07:24 AM

Missing secondary index after TDMS data deletion

75 Views

We have done a TDTIM transfer to a single client system. The deletion technique used by TDMS is Drop-insert technique.

During our initial analysis, we found that many of the secondary indices are not re-created by TDMS at database level. For many few tables the secondary indices are re-created at the database level.

  • Will TDMS delete and re-create the secondary index for re-created (droped & created) tables during data deletion in receiver system ?

  • Why did TDMS re-create secondary indices for few tables and why it didnot re-create secondary indices for few other tables?

Thanks

Praven