A NONCLUSTERED HASH index provides the most benefit for point lookups. It provides no discernible benefit if a query is running ...