Can we create clustered index on non primary key column
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
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What does man by sql wildcard characters in sql server?
What is an active database?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What is the command dbcc checkdb used for?
Explain the dbcc pintable command when would you use it?
How to delete exactly duplicate records from a table?
How can we get count of the number of records in a table?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What is the purpose of object explorer and its features? : sql server management studio
List types of tables in SQL Azure?
What is database black box testing?
What is ssl in sql server?
How is sql server used?