Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 7487 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 is the use of commit?
What do we have to check in database testing?
What happens if time-only values are provided as date and time literals?
What is normalization process?
Explain cross join or cartesian product in sql?
What is it’s similarity with sql server?
What is tempdb in sql server?
What are the different types of lock modes in sql server 2000?
Why the trigger fires multiple times in single login?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What samples and sample databases are provided by microsoft?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Why does sql studio use a single registered database repository? : sql server management studio
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
How to convert numeric values to integers in ms sql server?
