The NO_EXPAND hint prevents the cost-based optimizer from considering OR-expansion for
queries having OR conditions or INLISTS in the WHERE clause. Normally, the optimizer would
consider using OR expansion and use this method if it decides the cost is lower than not
using it.

SELECT /*+ NO_EXPAND */ name, salary
FROM emp
WHERE cost_center=9
OR cost_center=10;