Use of Hash Indexes Hash indexes are never required. Instead, you should use single‑table join indexes as needed.