Which of the following is not a good guideline for deciding when to create an index for a column? a. the column is a foreign key. b. the column contains a large number of unique values. c. the column is frequently used in search conditions or joins. d. the column is frequently updated.

d. The column is frequently updated.

Explanation:

An index holds the information of in which columns certain information can be found, based on this information I can say that one bad guideline would be if the column is frequently updated. This is because if the column is frequently updated then you would need to frequently update the index as well because the information will move, and the whole purpose of an index is to know where the information is at all times.

I hope this answered your question. If you have any more questions feel free to ask away at .

answer; collective security;