RE: Q: Clustered indexes

Robert, Creating a clustered index on a table does not affect future inserts or updates. That is to say, new inserts/updates ignore the cluster flag. So, no performance hits. (I think the only reason the cluster flag remains set is so you get an error if you try to cluster on another index.) If your table undergoes frequent inserts or updates, plan on performing the alter table on a regular basis. --Craig (craig@chemistry.utah.edu) > >Altering an index to cluster is one way to rebuild a table. >Clustering can also de done for performance reasons. Are there any >advantages, or any overheads, in leaving a cluster index with the >cluster flag set? > >Are there any advantages in immediately altering a clustered index to >"not clustered!? >