Description should include the following questions and issues that can affect the runtime speed of the query:

When the following are true, an index should be created:

When the following are not true, an index should not be created: