From: erik.lennart.jonsson@gmail.com   
      
   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?   
      
   /Lennart   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)