Groups > comp.databases.ms-sqlserver > #848

Re: question on clustered indexes in sql-server

From	"Bob Barrows" <reb01501@NOSPAMyahoo.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: question on clustered indexes in sql-server
Date	2011-11-29 12:03 -0500
Organization	A noiseless patient Spider
Message-ID	<jb3388$vjm$1@dont-email.me> (permalink)
References	<jb2ucg$tq7$1@dont-email.me>

Show all headers | View raw

Lennart Jonsson wrote:
> What is the purpose of a clustered index in sql-server (as you
> probably have guessed I have zero to none experience with sql-server)?
>
> The reason I ask is because I look at a databas where more or less all
> tables are designed as:
>
> create table T (
> x int IDENTITY(1,1) NOT NULL,
> [...]
> CONSTRAINT ... PRIMARY KEY CLUSTERED ( x ) ...
>
> In db2 I would look at range predicates and order by clauses on
> queries to determine what index that should be clustered (inorder to
> avoid sorts).
>
> What is the rationale to use a clustering index like the one above?
>
Kimberly Tripp sums up the debate (and there is, indeed, some controversy 
about this) quite nicely here:
http://sqlskills.com/BLOGS/KIMBERLY/post/The-Clustered-Index-Debate-again!.aspx

Make sure you follow the links near the beginning of the article.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

question on clustered indexes in sql-server Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2011-11-29 16:39 +0100
  Re: question on clustered indexes in sql-server "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-11-29 12:03 -0500
    Re: question on clustered indexes in sql-server Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2011-11-29 18:39 +0100
  Re: question on clustered indexes in sql-server Erland Sommarskog <esquel@sommarskog.se> - 2011-11-29 23:45 +0100
    Re: question on clustered indexes in sql-server Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2011-11-30 15:30 +0100
      Re: question on clustered indexes in sql-server Erland Sommarskog <esquel@sommarskog.se> - 2011-11-30 23:33 +0100
        Re: question on clustered indexes in sql-server Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2011-12-01 10:25 +0100
          Re: question on clustered indexes in sql-server Erland Sommarskog <esquel@sommarskog.se> - 2011-12-01 23:55 +0100
            Re: question on clustered indexes in sql-server Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2011-12-02 08:32 +0100

csiph-web