SQL Performance (MOSC)

MOSC Banner

explain plan

edited Nov 18, 2014 10:00AM in SQL Performance (MOSC) 7 commentsAnswered

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     |

-------------------------------------------------------------------------------------------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center