Database Tuning (MOSC)

MOSC Banner

Need Assistance In Interpreting SQL Tuning Advisor Recommendation

edited Jun 23, 2011 8:44PM in Database Tuning (MOSC) 7 commentsAnswered ✓
 Hi Folks

I was wondering if someone could explain to me (in plain terms) what the SQ Tuning Advisor is telling me here
in 1 and 2

I included the SQL for reference

Any suggestions are welcome


Thannks
Jim

1.
The predicate TRUNC("A"."AUDITDATE")>=TO_DATE(:B1,'yyyymmdd') used at line ID 3
of the execution plan contains an expression on indexed column "AUDITDATE".
This expression prevents the optimizer from selecting indices on table "LLTEST"."DAUDITNEW".

Rewrite the predicate into an equivalent form to take advantage of indices.
Alternatively, create a function-based index on the expression.


2.
The predicate TRUNC("A"."AUDITDATE")<TO_DATE(:B1,'yyyymmdd') used at line ID 3

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