How does the Index update process works?

Edhy Rijo — Fri, 31 Aug 2012 10:27:22 GMT

Hi Trent,

I have a customer with a table with 86 million records, this table is growing up constantly on a weekly basis at a rate of 700,000 records, so I have to constantly monitor the performance and this includes having to modify or create new indexes.

My question is, when I modify an index in DDT, how does the process works internally, does the DDT process checks if the index needs to be modified, or it will simply re-create all the indexes from scratch?

I want to know, because sometimes I don't make changes to this table at all, but the DDT process takes too long, so I am under the impression that the indexes in this table are being re-created even when nothing change in the DDT versus the current customer table.

Thanks!!!

StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » How does the Index update process works?

How does the Index update process works?