Interested to Buy Any Domain ? << Click Here >> for more details...
Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 8999 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
How do I start and stop sql server?
what is database replicaion? : Sql server database administration
What is a covering index?
What is named query? : sql server analysis services, ssas
What is the difference between a "where" clause and a "having" clause?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is merge replication?
What are the different types of columns types constraints in the sql server?
Can we use max in where clause?
how to define testing of network layers? : Sql server database administration
which table keeps the locking information? : Sql server administration
Explain contrast amongst grouped and non-bunched records?
What is the difference between indexing and hashing?
when you create a database how is it stored? : Sql server database administration
What is transact-sql language?
