Interested to Buy Any Domain ? << Click Here >> for more details...
Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 9180 Views
- Progressive, I also Faced
- E-Mail Answers
Answer Posted / hari
while creating primary key it will create cluster index.
while creating unique key it will create noncluster index
---cluster index it will create only one per table
---Non Cluster index it will create up to 249 per table
--cluster index physical sort the data
--Non cluster index logical sort the data.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why do we need normalization?
How do I find information about the install locations for the various instances running on a computer?
Explain acid?
What is the difference between dropping a database and taking a database offline?
What is shrink log file?
What is co-related sub query?
What is ms sql server index?
Why olap is used?
What is isnull() operator?
What is the maximum size per database for sql server express?
what is a schema in sql server 2005? : Sql server database administration
What is SQL Azure Federations?
What does asynchronous call backs means?
How can I create a new template for import ? : sql server management studio
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
