ahmed7.bi (12/12/2010)

---

Hi

i have read that only one unique clustered index can be created on a table and many non clustered index

then how come the below commands works fine as it is creating a unique clustered index on 2 columns of a table


create table test4 (id int,pid int,pname char(25))

go

create unique clustered index indx_test on test4 (id, pid) --
if the above case is right then how many columns can we include in a clustered index.???

ahmed7.bi (12/12/2010)

---

as mentioned above i have inserted below records


insert into test4 values (1,1,'asd')
go
insert into test4 values (2,1,'asd')

the command executed successfully

my query is that as i have included first two columns in the unique clustered index then how can it accepts duplicates in column 2 ..the what is the use of defining column 2 in unique clustered index ?????????

ahmed7.bi (12/12/2010)

---

if the above case is right then how many columns can we include in a clustered index.???

ahmed7.bi (12/12/2010)

---

i have read that only one unique clustered index can be created on a table and many non clustered index

then how come the below commands works fine as it is creating a unique clustered index on 2 columns of a table

Abhijeet Chavan (12/14/2010)

---

beginners SQL book will really help to understand the concept of Indexes.

When we say clustered index can also have non unique rows, so how sql manages to search a row.