Thoughts, opinions, samples, tips, and tricks about Microsoft Access
"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