Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54924 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / grish varshney
yes, we can create the cluster index on non prime attribute
if it is unique & there is no prime attribute bcoz the
cluster index should be once..
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What are the different authentication modes in sql server? How can it be changed?
What is primary key index?
How to use the inserted and deleted pseudo tables?
Tell me extended events in sql server 2008?
How to create a local temporary stored procedure?
can SSRS reports Cache results?
How to set a database state to offline in ms sql server?
What is candidate key with example?
What is the security principal at the server level that represents your session?
What are the different types of collation sensitivity?
What is the difference between stored procedure and functions?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is the difference between a primary key and a unique key? Are they the same?
How to rebuild the master database?
How will you find out if there are expensive SQL statements running or not?
