Can we create clustered index on non primary key column
Answer Posted / sandeep
Yes, We can, only thing is that, we can create clustered
index only on one key.If table contains any clustered index
on any key(even on primary or on unique key) just drop it
and create it on desired key. after it you can create a non
clustered index on primary or on unique key.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is meant by indexing?
Explain partitioned view?
Explain what is lock escalation?
How to insert stored procedure result into temporary table?
What is sql server profiler?
Can you name some of the dml commands in sql?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
How can you ensure that the database and sql server based application perform well?
what do you understand by change data capture?
How and why use sql server?
Explain transaction server explicit transaction?
What is the difference between a stored procedure and a user defined function?
Explain the microsoft sql server delete command?
What is a result set object returned by odbc_exec()?
What is the most common type of join?