SQL Performance (MOSC)

MOSC Banner

query tuning issue

edited Dec 24, 2016 4:00AM in SQL Performance (MOSC) 11 commentsAnswered

I created a functional index on "sum(coalesce(INDICATED_REVENUE,0) - coalesce(ACTUAL_REVENUE,0)) "  in query below query but still its very slow , what else can I try ?

the stats are current

select          

sum(coalesce(INDICATED_REVENUE,0) - coalesce(ACTUAL_REVENUE,0))      

from TAB1 t      

where t.tid = '925914455'            

and t. PM = '7'            

and t.Token is not null

Tagged:

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