Re: cluster index

I agree with Billy et al regarding the process for updating. I thought I might add that we use clustered indexes as a means of database maintenance. Every so often we will suspend use of the database, run appropriate clustered index creates, and then remove the indexes on completion of the run. This effectively compacts the tables (on S.E. at any rate) and gives us overall performance improvements. Dead useful for highly dynamic tables. Tim Kelly