Hint : NO_EXPAND

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;

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-985719/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-985719/