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 |