A developer adds a vector index hint because the optimizer chose another access path. What should happen before retaining the hint?

Published
  1. Measure correctness, recall, and latency on representative filtered queries
  2. Disable the application's authorization predicates
  3. Assume any hinted query has perfect recall
  4. Remove all SQL bind variables

Comments — 0