SQL Performance (MOSC)

MOSC Banner

parallel query tunning

edited Jul 4, 2017 5:01AM in SQL Performance (MOSC) 4 commentsAnswered

Hello experts,

                       One of our data extract job using external table is taking more than 2 hours in production.I am trying to tune that statement in production like environment.There is a large portioned table called reading for which query reads through each partition and as per awr sql report it reads 685G of data.I tied to force local index pk_reading  which has index on column NODEID, ENDTIME, READINGGROUPALTERNATEKEY but query ran for 12 hours.I am attaching qwr sql report with hint and without hint.Please tell me why my index hint is regressing the query?

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