Database Tuning (MOSC)

MOSC Banner

sql quary tunning recommandations

edited Jun 13, 2011 10:26AM in Database Tuning (MOSC) 7 commentsAnswered
hi all,

please see the below query  and tell me how i tune this sql query below is the tkprof report for this query

sql_query

========

Select

'Dear Customer, we have received the premium of Rs.' ||op.amt ||' against your policy ' || P.Policy_No ||' . Thank you for being a part of XXXXXXXXX.'

From Operations O,

Op_Prem_Payments Op,

Policy P

Where

trunc(sysdate) - trunc(O.Applied_Date) = 10

/* Not in Stop Letter */

And

Not Exists (Select 'X' From Pak_Stp_Ltr Psl Where Psl.Policy_No = P.Policy_No

)

And O.Status Is Null /* Applied Operation */

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