SAinCA, I think this is the code you are referencing from this tip ( http://www.mssqltips.com/tip.asp?tip=1112 ): -- Table - The base table is stored with the -- clustered index, so moving the clustered -- index moves the base table CREATE CLUSTERED INDEX IDX_ProductID ON dbo.OrdersDetail(ProductID)...