SQL Performance (MOSC)

MOSC Banner

Query plan and execution time varies with different decode values

edited Mar 5, 2015 10:04AM in SQL Performance (MOSC) 2 commentsAnswered

Hi All,

Query plan and execution time varies  between Decode "1" and "2" used in the query.

Attaching the plans for both the queries where one of them gets completed in 10 mins when decode 1 is used and other takes about 40 mins to complete when decode "2" is used in the query.,i know this is bit abstruse to read,still  requesting if anyone has any idea in solving this,

Thank you in advance.

SELECT A.BUSINESS_UNIT,

         A.PROJECT_ID,

         L.DESCR,

         A.ACTIVITY_TYPE,

         A.PROJECT_MANAGER,

         B.NAME,

         A.TEAM_MEMBER,

         C.NAME,

         A.RESOURCE_TYPE,

         A.RESOURCE_CATEGORY,

         M.DESCR,

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