Interested to Buy Any Domain ? << Click Here >> for more details...
Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 8796 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
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
What is the default sql server instance name?
What is SQL Azure?
how can a database be repaired? : Sql server administration
What does executeupdate return?
How connect excel to sql server?
Write an sql query for deleting duplicate rows?
What does the on delete cascade option do?
what is a mixed extent? : Sql server administration
Are resultset updatable?
What is the benefit of normalization?
How can you tell if a database object is invalid?
What is the use of partition by in sql server?
Explain primary key?
What are sql dirty pages?
