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

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1638

What are the disadvantages of primary key and foreign key in SQL?

1069

what is datawarehouse?

1069

What are different types of schemas?

901

How to create an inline table-valued function?

927

What command would you use to create an index?

1006

Can we use where clause with group by?

868

What is local temp table?

918

What is command parameter in ssrs?

157

What is lock escalation and what is its purpose?

934

What is the difference between TRUNCATE and DROP?

1085

How global temporary tables are represented and its scope?

925

What is the difference function and stored procedure?

1010

explain different types of backups avaialabe in sql server? : Sql server database administration

936

What is coalesce in sql server?

1009