SQL Performance (MOSC)

MOSC Banner

explain plan

On a 19.16 database I have the below Explain Plan for a query which I have improved by means of adding one index, but now I'm stuck with the below one, where I can't see how to improve it further.

Can you assist with this one ?

-------------------------------------------------------------------------------------------------------------------------------


| Id | Operation                               | Name                      | Rows | Bytes |TempSpc| Cost (%CPU)| Time    |


-------------------------------------------------------------------------------------------------------------------------------


|  0 | SELECT STATEMENT                        |                           | 87737 |   29M|      |  213K (1)| 00:00:09 |


|* 1 | HASH JOIN                              |                           | 87737 |   29M|   24M|  213K (1)| 00:00:09 |


|  2 |  NESTED LOOPS                          |                           | 87745 |   23M|      |  202K (1)| 00:00:08 |


|  3 |   NESTED LOOPS                         |                           |  330K|   23M|      |  202K (1)| 00:00:08 |


|  4 |    NESTED LOOPS                        |                           |  330K|   74M|      | 36942  (1)| 00:00:02 |


|  5 |     NESTED LOOPS                       |                           | 60565 |   12M|      | 6643  (1)| 00:00:01 |


|  6 |      TABLE ACCESS BY INDEX ROWID       | GL_JE_CATEGORIES_TL       |    1 |   30 |      |    1  (0)| 00:00:01 |


|* 7 |       INDEX UNIQUE SCAN                | GL_JE_CATEGORIES_TL_U2    |    1 |      |      |    1  (0)| 00:00:01 |


|  8 |      TABLE ACCESS BY INDEX ROWID BATCHED| GL_JE_HEADERS             | 60565 |   10M|      | 6642  (1)| 00:00:01 |

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