My query goes for full tablescan even though there are indexes
Plan hash value: 1821333644
---------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
---------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 3895 | 2426K| | 899K (1)| 00:00:36 |
| 1 | SORT ORDER BY | | 3895 | 2426K| 38M| 899K (1)| 00:00:36 |
| 2 | WINDOW BUFFER | | 3895 | 2426K| | 899K (1)| 00:00:36 |
| 3 | SORT GROUP BY | | 3895 | 2426K| 38M| 899K (1)| 00:00:36 |
|* 4 | FILTER | | | | | | |
|* 5 | HASH JOIN | | 59815 | 36M| | 882K (1)| 00:00:35 |
|* 6 | TABLE ACCESS FULL | W_PROJECT_D_TL | 783 | 27405 | | 7 (0)| 00:00:01 |
|* 7 | HASH JOIN | | 59853 | 34M| | 882K (1)| 00:00:35 |
| 8 | TABLE ACCESS FULL | W_PROJECT_D | 783 | 17226 | | 22 (0)| 00:00:01 |
|* 9 | HASH JOIN | | 59853 | 33M| | 882K (1)| 00:00:35 |
| 10 | TABLE ACCESS FULL | W_SUPPLIER_ACCOUNT_D | 14966 | 833K| | 453 (1)| 00:00:01 |
|* 11 | HASH JOIN | | 59853 | 29M| 3720K| 882K (1)| 00:00:35 |
| 12 | TABLE ACCESS FULL | W_GL_ACCOUNT_D | 55158 | 3070K| | 2777 (1)| 00:00:01 |
|* 13 | HASH JOIN | | 17590 | 8022K| | 879K (1)| 00:00:35 |
| 14 | VIEW | index$_join$_015 | 14966 | 394K| | 157 (1)| 00:00:01 |
|* 15 | HASH JOIN | | | | | | |
|* 16 | HASH JOIN | | | | | | |
|* 17 | HASH JOIN | | | | | | |
| 18 | BITMAP CONVERSION TO ROWIDS | | 14966 | 394K| | 38 (0)| 00:00:01 |