Appreciate all help. Now; does it differ if COL1 was not primary key and not indexed (COL1 is numeric(p,0))

Server is: SQL 2000, SP3