Author Question: Explain SQL Server indexes. What will be an ideal response?[br][br][b][color=#FA1639]Question ... (Read 77 times)

anjilletteb · **on:** Jul 7, 2018

Explain SQL Server indexes.

What will be an ideal response?

Question 2

A null value in a column may indicate that there is no appropriate value for that attribute.

Indicate whether the statement is true or false

DHRUVSHAH · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

There are two types of SQL Server indexesclustered and nonclustered. Clustered indexes store data at the bottom level of the index and in the same order as the index. In nonclustered indexes, the bottom level of the index holds pointers to the data instead of the data itself. Since data can only be sorted in one physical order at a time, there can be only one clustered index per table. Clustered indexes are faster for data retrieval. SQL Server automatically creates indexes for all primary and foreign keys. Database developers can create others as needed.

Answer to Question 2

TRUE