When reading the base rowset of the unique table, the predicate on the value column can be pushed down to the storage engine for filtering.
Normally, the base rowset is the largest rowset in the entire table, so it can speed up the query.