Answer Posted / indranil

The clustered index is SORTED, and the nonclustered index is
UNSORTED.

For example, we have a pile of birth certificates in City
Hall, and we're going to make an index by birthday (birth
date, to be more exact.)

With a nonclustered index, it's like you have a bunch of
paper lists, each paper with a date, and the people born
under that date. You can quickly determine all people who
were born on August 4, 1986. However the papers themselves
are not sorted, so if you wanted to know all people born in
1986, or August 1986, you'll have to go through all the papers.

With a clustered index, the birth certificates themselves
are sorted by birth date, so searching for people born in
1986, or August 1986, January-June 1981, or any date range
is much faster. Also, it is easier to sort all the people by
birth date (since the data is already sorted).

How to make a remote connection in a database?

969

---

Can you explain important index characteristics?

985

---

How to drop an existing stored procedure in ms sql server?

1024

---

How self join is different from outer join?

1113

---

Why it is recommended to avoid referencing a floating point column in the where clause?

954

---

How to loop through returning rows?

1028

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

988

---

What is transaction server isolation?

1030

---

Can you edit the .rdl code associated with a linked report?

163

---

How do I start sql server 2017?

929

---

Explain log shipping?

1006

---

What are recommended options to be used while using db mirroring? : sql server database administration

1145

---

How to join two tables in a single query in ms sql server?

986

---

What to check if a User database is locked?

1060

---

Characterize join and name diverse sorts of joins?

964

---