Won't the indexes get heavily fragmented if he does not truncate or drop and re-create?

That is a concern for sure.

MH