October 26, 2004 at 10:56 am
Someone told me that whenever an application insert a record into the database the database will reindex all records for that specific table that it is inserting in. Is that true? Thanks for helping me.
October 26, 2004 at 11:13 am
Not true.
It will add an entry into every index affected by the row (aka record) inserted, but "reindex" is a total different thing than "index insert"
Reindexing typically is handled directly by using a DBCC/database maintenance job on a periodic or as-necessary basis.
Any man who can drive safely while kissing a pretty girl is simply not giving the kiss the attention it deserves. ~ Albert Einstein
October 27, 2004 at 9:06 am
When a record is inserted it fills the free space available on page. If no space then split the page and add record. Reindex on the other hand recreate the index with the specified fill factor.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply