强制让SQL走谓词推入

SELECT *
  FROM STORESUM
 WHERE (ORG_ID IN (SELECT EP_LOC.ORG_ID
                     FROM EP_LOC, EP_USER_LOC
                    WHERE EP_LOC.LOC_ID = EP_USER_LOC.LOC_ID
                      AND EP_USER_LOC.USER_ID = :1) AND
       ((STORE_ID IN (SELECT STORE_ID FROM STOREMAS_LOC WHERE LOC_ID = :2)) OR
       (STORE_ID IN
       (SELECT STORE_ID FROM EP_USER_STORE WHERE USER_ID = :3))))
 ORDER BY STORE_ID DESC, STK_ID ASC


xabd@RBDBON8> select * from table(dbms_xplan.display());

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 2885993211

----------------------------------------------------------------------------------------------------------------
| Id  | Operation			   | Name	       | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
------------------------------------------------------------------------------