I have a table with non-clustered index e.g. Index1 on Column1, Column2 & Column3
Now i want to create a clustered index2 on column1.
Index creation time point of view, does it make any difference if the column is being used by other index?
asked Feb 22, 2010 at 11:03 AM in Default
In direct answer to your question, no.
But creating a clustered index will physically order the data on the disk, so will take more time than creating a non-clustered index.
answered Feb 22, 2010 at 11:37 AM
Matt Whitfield ♦♦
Based on your first index; Column1, Column2, Column3, I'd consider the second index on Column1 to be redundent. Of cousre, there is always that "It Depends" when it comes to any development.
answered Feb 24, 2010 at 03:25 PM