Do I understand correctly that the core problem is trying to override the
plan for a specific SQL, wanting to use the hint table so that the SQL text
itself doesn't need to be changed, but the values that have been tried in
the hint table haven't changed the plan yet for the SQL which is executed
later?
Do you have a simplified set of steps that someone else could run, which
demonstrate the problem? Like some statements to create a dummy table and
then create a hint table entry which "should" work and then running a query
that is not impacted by the hint?
-Jeremy