Re: Clustered Index Question

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: ChrisR (anonymous_at_discussions.microsoft.com)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 14:24:52 -0700

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
    ... Actually it should be slightly faster than if it were just a heap. ... > Updates be any slower since you cant Update an Identity ...
    (microsoft.public.sqlserver.server)
  • Re: Bulk inserting into database using ADO.NET... deadly slow?
    ... program (look in your SQL Server documentation for "BULK INSERT"). ... > the DataSet, so to reduce the DB updates, but I found that when reaching ... > about 100K rows the DataSet becomes slower and slower, ... why is it so painfully slow to insert big chunks ...
    (microsoft.public.dotnet.framework.adonet)
  • Bulk inserting into database using ADO.NET... deadly slow?
    ... the DataSet, so to reduce the DB updates, but I found that when reaching ... about 100K rows the DataSet becomes slower and slower, each insertion taking ... why is it so painfully slow to insert big chunks of ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Windows Update Page Slow
    ... Have it send you the updates but let you install them. ... I tried running IE with add-ons turned off and it is basically the ... slower and slower. ...
    (microsoft.public.windowsxp.general)
  • Re: How to Update fields based on values of other fields
    ... Have fun if you decide to go with the updates. ... There is certainly a heap to learn with Access, since it gives you so many ... Tips for Access users - http://allenbrowne.com/tips.html ...
    (microsoft.public.access.reports)