Re: Help - Clustered Index to Keep the Table in Desired Order

dave, > And you will wind up with a table that is effectively unclustered. The ONLY w are you saying that if i create a table, then create a clustered index, then load the data, the data will not be clustered? that the clustering only takes affect *after* there is data in the table? ahhh.... as i think of it though, the cluster is not maintained, i forgot about that. so doing an initial load is like loading any other data, and so the cluster isn't maintained. the cluster only takes affect when you build the index with data in the table. is this correct? mickm