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
What is the meaning of sql server?
Explain important index characteristics?
What are the main sources of data?
When columns are added to existing tables, what do they initially contain?
How many levels of sp nesting is possible?
What is the impact on other user sessions when creating indexes?
What is difference statement and preparedstatement?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What do you understand by a view? What does the with check option clause for a view do?
List the different index configurations possible for a table?
What is sql injection and why is it a problem? : sql server security
What is normalization? Explain its different types?
What is the maximum size per database for sql server express?
Do you know spatial data types - geometry and geography in sql server 2008?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.