Which of the Following Is Not True About the Difficulty

Multiple Choice

Which of the following is not true about the difficulty of index selection?

A) The number of choices of indexes is linear in the number of columns
B) The query optimizer may have subtle reasons not to use an index
C) Values of parameters used in SQL statements of forms often vary from highly selective to not very selective
D) Index choices can be interrelated in a subtle way