explain plan
The below sql is taking lot of time, what can be done to improve the sql performance:
SELECT
/*YANTRA*/
YFS_ORDER_HEADER_H.*
FROM YFS_ORDER_HEADER_H YFS_ORDER_HEADER_H
WHERE(((YFS_ORDER_HEADER_H.ORDER_NO <> :1)
AND(YFS_ORDER_HEADER_H.EXTN_RESHIPPED_FLAG = :2)
AND((YFS_ORDER_HEADER_H.CUSTOMER_EMAILID = )
OR(YFS_ORDER_HEADER_H.EXTN_IP_ADDRESS = :4)
OR(YFS_ORDER_HEADER_H.CUSTOMER_PHONE_NO = :5))))ORDER BY YFS_ORDER_HEADER_H.ORDER_DATE DESC
Explain Plan output:
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 2622252782
-------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
-------------------------------------------------------------------------------------------------