Re: Clustered Index Question

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 23:34:46 +0200

It depends on which columns you modify. If you modify a column which is part of the clustered index,
the row need to be moved. If you modify a column which is part of a non-clustered index, then the
non-clustered index need to be modified accordingly. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ChrisR" <anonymous@discussions.microsoft.com> wrote in message 
news:254001c4a4d8$6d1a0710$a501280a@phx.gbl...
> Would Updates be the same?
>
>
>>-----Original Message-----
>>Actually it should be slightly faster than if it were
> just a heap.  A heap
>>has to do some lookups to determine where to place the
> next row that have a
>>slight bit of overhead.  A CI insert with a
> monotonically incrementing value
>>is a no brainer per say for SQL Server.  As you stated
> it goes to the end of
>>the last page.
>>
>>-- 
>>Andrew J. Kelly  SQL MVP
>>
>>
>>"ChrisR" <anonymous@discussions.microsoft.com> wrote in
> message
>>news:31d601c4a4d4$5d7139e0$a301280a@phx.gbl...
>>> sql2k sp3
>>>
>>> If my Clustered Index is an Identity Coulmn, should
>>> Inserts still be slowed down. In other words, since a
>>> newly Inserted row should be stored at the end, why
> would
>>> it be any slower than when theres no Clustered Index?
> It
>>> shouldnt need to reorganize anything. Aslo, should
>>> Updates be any slower since you cant Update an Identity
>>> field anyways?
>>>
>>> TIA, ChrisR
>>
>>
>>.
>>

Relevant Pages

  • Re: Clustered Index Question
    ... will happen regardless of the column the CI is on if the data won't fit. ... > It depends on which columns you modify. ... >>>Andrew J. Kelly SQL MVP ... >>>> If my Clustered Index is an Identity Coulmn, ...
    (microsoft.public.sqlserver.server)
  • Indexed Views Considerations
    ... After the clustered index is created, any connection ... attempting to modify the base data for the view must also ...
    (microsoft.public.sqlserver.programming)
  • Re: Checkpoint causes need for better IO subsystem?
    ... maybe it's not the IO and that maybe it's an indexing performance issue. ... Microsoft SQL Server MVP ... is this a monotonically increasing indexing scheme that I've created? ... the Clustered index is on multiple cols... ...
    (microsoft.public.sqlserver.tools)
  • Re: Indexes
    ... because we have a clustered index but I was expecting ... Only one row fit per page, so SQL Server ... You have 100000 rows in the table and 1000 rows fit per index page. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Checkpoint causes need for better IO subsystem?
    ... excellent articles on clustered index selection and its impact on ... clustered index sql kimberly tripp ... Microsoft SQL Server MVP ... the random write capability of the drives comes into play, ...
    (microsoft.public.sqlserver.tools)