Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 7451 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
What are the Advantages of using CTE in sql server?
How to see existing views in ms sql server?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What is unique key constraint?
What is sql server agent and what are the two modes of authentication in sql server?
Explain go command in sql server?
Is it possible to have clustered index on separate drive from original table location?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What is the default schema of your login session in ms sql server?
Where are sql server user names and passwords stored in sql server?
What is Sqlpaging in SqlServer 2005 ?
Define union, union all, minus, intersect?
How to use user defined functions in expressions?
Why does sql studio use a single registered database repository? : sql server management studio
