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

Re: question on clustered indexes in sql-server

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: question on clustered indexes in sql-server
Date	2011-11-30 23:33 +0100
Organization	Erland Sommarskog
Message-ID	<Xns9FADEFAF7E378Yazorman@127.0.0.1> (permalink)
References	<jb2ucg$tq7$1@dont-email.me> <Xns9FACF1B805663Yazorman@127.0.0.1> <jb5eld$cj7$1@dont-email.me>

Show all headers | View raw

Lennart Jonsson (erik.lennart.jonsson@gmail.com) writes:
> If I got it right, the leaf pages in a clustered index in sql-server is
> the data pages. 

Yes, that is exactly essense.

> In db2 leaf pages contains a pointer to the data page just like any
> other index. 

So then in DB2, what is the difference between a clustered index and a
non-clustered index?



-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

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