function on key defeats elimination | | Host variable | `WHERE trans_date >= ?` | Depends — may use partition elimination at bind/execute time |