Wednesday, December 3, 2008

Access 101: What is an Index?

You can find this article here: What is an Index?

1 comment:

Tony Toews said...

"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.