The General Guidelines of Whether to Create Indexes in a Database

When you are considering whether to create an index, evaluate two factors to ensure that the index will be more efficient than a table scan: the nature of the data and the nature of the queries based on the table.