ae7414ee   
   From: sorrytoomuchspamalready@xs4all.nl   
      
   The physical order is determined by the clustered index. If your table   
   does not have a clustered index, then add one.   
      
   Having said that, even the clustered index will determine the physical   
   order only up to a certain point. A particular page will have all the   
   rows that according to the logical order belong on that page, but might   
   still physically store them out of order.   
      
   Why do you want them to be physically ordered? I hope you realize that   
   the only way to retrieve the rows in any defined order is by specifying   
   the order with the ORDER BY clause of the query.   
   --   
   Gert-Jan   
      
      
   Markei54545 wrote:   
   >   
   > Is there a way to physically re-order the records in an MS SQL 2005   
   > table?   
   >   
   > Many thanks   
   >   
   > Mark   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)