Sql server - Determine when an index is appropriate

Determine when an index is appropriate.

a. When there is large amount of data. For faster search mechanism indexes are appropriate.
b. To improve performance they must be created on fields used in table joins.
c. They should be used when the queries are expected to retrieve small data sets
d. When the columns are expected to a nature of different values and not repeated
e. They may improve search performance but may slow updates.
Sql server - Syntax and an example for create, rename and delete index
CREATE INDEX index_name ON table_name (col_1,col_2..);........
What is a join and explain different types of joins
Joins are used in queries to explain how different tables are related........
What is a self join in SQL Server?
Two instances of the same table will be joined in the query...
Post your comment