Why my indexscan is not getting picked up in the below query and going for parallel sequence scan even after set sequence Off , function index created
(
SELECT
Example_id
FROM
Table.Example
WHERE
TRANSLATE(LTRIM(PLCY_NBR, ‘0’), ‘-~’, ”) like’35243′
)
UNION
(
SELECT
EXAMPLE
FROM
TABLE.EXAMPLE
WHERE
EXAMPLE.SRC_SYS_ID = 14
AND TRANSLATE(LTRIM(PLAN_NBR, ‘0’), ‘-~’, ”) like’34123′
);