Database Tuning (MOSC)

MOSC Banner

Need to Improve the performance on the Query attached

edited May 16, 2010 8:42PM in Database Tuning (MOSC) 3 commentsAnswered
 Hi , I would like to improve the perfromance of the follwoing query and also attached below  is the Exceution plan . Any help is much appreciated !

SELECT
       GL.code_combination_id                                                     CCID,        --1
       GP.period_year                                                             Prd_year,    --2
       GL.period_name                                                             Prd_name,    --3
       GB.je_batch_id                                                             batch_id,    --4
       GB.name                                                                    Batch,       --5
       GH.je_header_id                                                            hdr_id,      --6
       GH.name                                                                    Journal,     --7
       GS.user_je_source_name                                                     source,      --8
       GH.currency_code                                                           Currency,    --9
       GL.description                                                             Jnl_desc,    --10
       TO_CHAR(GL.effective_date, 'DD/MM/RRRR HH:MI')                             Eff_date,    --11
       TO_CHAR(GH.posted_date,    'DD/MM/RRRR HH:MI')                             Post_date,   --12

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