we can creta clustered index on non primary column. create table abc(eid i

Can we create clustered index on non primary key column

Question Posted / ashok

Answer Posted / ashok

we can creta clustered index on non primary column.
create table abc(eid int,ename varchar(50))
create clustered index abc_clustered on abc (eid)

Is This Answer Correct ?

67 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What is a db view?

853

What is unique key constraint?

987

Explain indexes disadvantages?

1009

What is sub-query in sql server? Explain its properties.

1039

What is the filtered index?

975

What stored procedure can you use to display the current processes?

834

What do mean by xml datatype?

1005

What is the purpose of sql profiler in sql server? : sql server database administration

1042

What are points to remember while using the fillfactor argument?

906

What is encryption key?

117

What is after dml trigger?

953

How do I view a trc file?

897

Can we insert data into a view?

1061

What according to you is the difference between mysql and sql server performance?

1021

Explain the dirty pages?

950