The index one sees in the beginning of a book is a clustered index and th

Difference between Cluster and Non-cluster index?

Question Posted / helps

Answer Posted / helps

The index one sees in the beginning of a book is a
clustered index and the index one sees at the end of the
book is a non clustered index.

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain atomicity?

1123

What are the disadvantages of using the stored procedures?

1183

What are indexes in ms sql server?

1113

What does COMMIT command do?

1119

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1085

What is nonclustered index with included columns ?

1014

How to execute a sql statement using mssql_query()?

1102

How many types of stored procedures are there in sql server?

1055

What are rows and columns?

1062

What is xdr?

1041

What is query and its types?

951

What is provisioning, billing and metering, and connection routing concepts in the service layer?

115

What is the difference between a stored procedure and a user defined function?

1061

What is the sql profiler?

998

Can another user execute your local temporary stored procedures?

1023