Re: Clustered Indices

Sounds like application developer needs to be educated on when to use clustered indexes and when not. The developers needs to be educated, this will make life for the DBA easier ===================================================================== Paul Watje Database Something or Another watjep@hasting.com Hastings Books, Music, & Video :On Mon, 15 May 1995, Cathy Kipp wrote: : :> The manual may be misleading (I haven't looked at this section recently), :[snipped] :> :> Regards, :> :> - Cathy : :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? : :Is there a performance penalty for using a clustered index in this :circumstance? Clustered index taking up more disk space? Query optimiser :making the wrong guess because rows are not in the expected order? : :Ideas appreciated. : :Pete Harris