A sequential scan that is the right plan

• A

  Force the index with a hint, since an index is always faster than a scan

• B

  Rebuild the index, which must surely be bloated or corrupt for the planner to skip over it

• C

  Update the statistics so the planner knows the index is selective

• D

  Leave it; reading a small table straight through is cheaper than an index lookup per row