(
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′
);
I set random_page_cost = 1.0;
Set seq_page_cost = 1.0;
Even after creating gin index for like planning time is reducing but execution time is same. I need to optimise the query
New contributor
rohini M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.