From: erik.lennart.jonsson@gmail.com   
      
   On 2011-11-30 23:33, Erland Sommarskog wrote:   
   [...]   
   >> 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?   
   >   
      
   If the index is clustered the data pages are ordered according to the   
   clustering index. When a row is inserted, db2 finds the page where the   
   row should reside. If the row does'nt fit there, db2 looks in a   
   neighbourhould of the page. If that does not succedd etheir, the row is   
   put at the end. In these cases a pointer to the chosen page is stored in   
   the page where the row should have been. If there are many "overflow"   
   pages in a table, additional I/O is required when reading pages, and a   
   reorg of the table should be performed.   
      
   For a table without a clustering index db2 store the rows in no   
   particular order.   
      
      
   /Lennart   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)