"Every time a new record is added, all the indexes need to be rebuilt." This would be best stated as "Every time a new record is added, all the indexes need to be updated." The entire index is not rebuilt every time a record is added.
And of course if a record is deleted then the indexes are also updated accordingly.
Although minor note that indexes on a given field are updated if that field is also updated.
1 comment:
"Every time a new record is added, all the indexes need to be rebuilt." This would be best stated as "Every time a new record is added, all the indexes need to be updated." The entire index is not rebuilt every time a record is added.
And of course if a record is deleted then the indexes are also updated accordingly.
Although minor note that indexes on a given field are updated if that field is also updated.
Post a Comment