Hi everyone,
I am a new baby in Oracle and plus ODI 12c. Shortly my question is about adding hints to ODI. My query is;
SELECT /*+ full(s) */
s.sip_date,
con.seg_behavior,
s.organization_id,
SUM (CASE WHEN s.no IS NULL THEN 1 ELSE 0 END) num_cust_without_card,
COUNT (s.no) num_cust_with_card,
COUNT (1) num_total_cust,
COUNT (con.tmv_id) num_cust_with_segcard
FROM xxmg_siparis s
LEFT JOIN tmv.contact con ON s.tmv_id = con.tmv_id
WHERE s.sip_date >= TRUNC (ADD_MONTHS (SYSDATE, -3), 'mm')
AND s.status = 5
GROUP BY s.sip_date, con.seg_behavior, s.organization_id
However, the running query in ODI is;
SELECT
s.sip_date,
con.seg_behavior,
s.organization_id,
SUM (CASE WHEN s.no IS NULL THEN 1 ELSE 0 END) num_cust_without_card,
COUNT (s.no) num_cust_with_card,
COUNT (1) num_total_cust,
COUNT (con.tmv_id) num_cust_with_segcard
FROM xxmg_siparis s
LEFT JOIN tmv.contact con ON s.tmv_id = con.tmv_id
WHERE s.sip_date >= TRUNC (ADD_MONTHS (SYSDATE, -3), 'mm')
AND s.status = 5
GROUP BY s.sip_date, con.seg_behavior, s.organization_id
I want to add /*+ full(s) */ hint to my query. How can I accomplish it? I searched google a lot, but Please help me.
Thank you