Difference between Cluster and Non-cluster index?
Answer Posted / yashpal
Clustered index will be created by default when u
create primary key on a column. only one clustered index is
created per table
Non clustered index will be created automatically when u
create unique key on a column. A table can have no.of
unique keys, so we can create no.of non clustered indexes
per table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Do you know what are various aggregate functions that are available?
what method you can use to reduce the overhead of Reporting Services data sources?
How does clustered and non clustered index work?
What is index in an assignment?
Is foreign key unique?
Explain why variables called the most powerful component of ssis?
How much does sql server 2016 cost?
Explain in brief about Microsoft SQL server?
What is bit data type? What's the information that can be stored inside a bit column?
How to delete duplicate records based on single column from a table?
Explain the different types of joins?
What happens if the update subquery returns no rows in ms sql server?
What is conditional split?
How many types of subqueries are there in sql server?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?