Re: Clustered Indices

Peter Harris (phr@fmsc.com.au) wrote: >So what happens when a clustered index is created on a dynamic table at >the moment of its creation and never again reclustered - which is quite >likely if the application developer is not the same person as the DBA? The clustering aspect of the table is wasted. I think you would be better off dropping the index and recreating the index so it wont be so loopsided. This is assuming that data was present in the table at the time the index was set to cluster. If the index was created before data was added I believe the index will act like a non-clustered index. I would suspect there is a little overhead for the unused cluster segments of the index but there should not be any performance issue with this. -- Carlton Doe "It's not *over* until I win!" DBA Resources, Inc. -- Les Brown Salt Lake City, UT dbaresrc@xmission.com http://www.xmission.com/~dbaresrc