Explain SQL Server indexes
What will be an ideal response?
There are two types of SQL Server indexes—clustered 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.
You might also like to view...
Which of the following cannot be an effective branding strategy for high-tech products?
a. create a steady stream of innovations with strong value proposition cobranding b. manage all points of contact with customers c. launch price promotions d. influence the influencers e. harness Web 2.0 technologies
Kantian ethics is based on the premise that people can use reasoning to reach ethical decisions
Indicate whether the statement is true or false