When would I need to do maintenance on a clustered index in SQL server
Posted on 2013-01-15
I am looking into creating some index maintenance jobs, and I am wondering when I would ever need to do maintenance on the clustered index. My understanding is that the data is stored with this index and physically ordered by the index. Most of the clustered indexes on the system are PK identity INT.
Any URLs on this topic would be great...Thanks!