Tag Info

New answers tagged

1

Lets answer your question as you asked create clustered index ix_index1 on table1(col1) create clustered index ix_index2 on table1(col2) You are creating a clustered index(CI) but as soon as you create CI on col1 you cannnot do it on col2 as on a table you can have only one CI. A CI is physically a table arranged in particular order. Since a table ...



Top 50 recent answers are included