Difference between Cluster and Non-cluster index?
Answer Posted / upma
when u create primary key in a table than cluster index are automatically created...becoz there can b only one primary key on a table,so cluster index is one in a table.cluster index reorder the way records in a table are physically stored...
Non cluster index,when u create unique automatically generated... 249 non cluster index in a table,because we can apply more than one unique key in a table..
logically order, does not match with physical order..
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to create an identity column?
What is equi join with example?
Distinguish between nested subquery and correlated subquery?
What is extended stored procedures?
Why should one not prefix user stored procedures with ‘sp_’?
What is history table in sql server?
What is raiseerror? What is raiseerror?
How to rebuild all indexes on a single table?
What is the library index called?
What are the main differences between #temp tables and @table variables and which one is preferred?
What is the partitioning method?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
Name some of the open source software that you can use in alternative to SSR?
What is surrogate key? : sql server analysis services, ssas
What is the difference between a stored procedure and a user defined function?