YES, We can create a clustered index on a non-primary column. Check the f

Can we create clustered index on non primary key column

Question Posted / pavan kumar

20 Answers
54896 Views
ABC, CTS, I also Faced
E-Mail Answers

Answer Posted / pavan kumar

YES, We can create a clustered index on a non-primary
column. Check the folowing queries...

CREATE TABLE EMPLOYEES
(
empid int NOT NULL CONSTRAINT ix_pkEMPLOYEES PRIMARY KEY
NONCLUSTERED
, name varchar(25) NOT NULL
, age tinyint NOT NULL
)

CREATE CLUSTERED INDEX ixcEMPLOYEES ON EMPLOYEES (name)

Is This Answer Correct ?

57 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do you know what is difference between index seek vs. Index scan?

955

what is unique and xaml nonclustered index

1051

Explain the different types of joins?

997

Introduction of rollup clause using sum and group by clause?

968

What is a trigger and its types?

991

What is the function of inner join?

1074

Is INSTEAD OF trigger directly applicable to Table ?

1017

What is query parameter in ssrs?

160

What is self contained scalar sub query?

974

How to start sql server browser service?

1136

What is data source in connection string?

910

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

883

What is the library index called?

1059

List the data types available in mssql?

1034

How self join is different from outer join?

1121