Difference between Cluster and Non-cluster index?
Answer Posted / naren
clustered index is created on actual data.
Non clustered index ix created on pointer of data.
If there is primary key by default clustered index is
created.
else non clustered index created.
only one clustered index is possible to create.
249 non clustered indexex can be created.
Is This Answer Correct ? | 59 Yes | 15 No |
Post New Answer View All Answers
Explain what is it unwise to create wide clustered index keys?
How to retrieve error messages using mssql_get_last_message()?
Explain different types of self contained sub query?
How to write character string constants or literals in ms sql server?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What are SSL and TSL protocols?
What is self join in sql server joins?
Can one drop a column from a table?
What are recommended options to be used while using db mirroring? : sql server database administration
What are the disadvantages of merge replication?
What do you mean by normalisation?
What are different types of raid configurations? : SQL Server Architecture
How you can find out if an index is useful to the optimizer?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?