yes we can create clustured index on non primary key, But that column has

Can we create clustered index on non primary key column

Question Posted / venkat

Answer Posted / venkat

yes we can create clustured index on non primary key,
But that column has unique values.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain what is public role in sql server?

1189

What is sql server management studio? : sql server management studio

1122

How do I debug a stored procedure in sql server?

1174

Define Unique Key?

1066

What are the options which must be set to allow the usage of optimistic models?

1020

What are the differences between local and global temporary tables?

1127

Define tempdb database?

1040

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1305

What is the difference between coalesce() & isnull()?

1187

What are the differences between lost updates and uncommitted dependencies?

1139

Does a sql server 2005 select statement require a from?

1071

What are the reporting services components?

144

What are the restraints imposed on the table design by a merge replication?

1087

What is sql service broker?

1021

What is 'write-ahead log' in sql server 2000 ?

1106