Unanswered: How do updates work on clustered tables?
Im considering a clustered index on a certain table,
the number of records in this table is going to be fixed,
nothing is ever erased however several columns on the records are updated.
the update never effects the clustered index column
this column is always the same. will the operation still
force deletion and insertion of the record including moving the page files around to maintain the cluster order?
the record contains several var binary columns so the actual size of the record might change with each update.
should I use a clustered index or will the updte performance loss be higher then the select gain.