I verified that VW_NSO_1 is not a user defined view.
but it seems that oracle some how defines this object.
Any idea what this object is and how it is made use of?
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 3445229878
--------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes
--------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 78
| 1 | SORT AGGREGATE | | 1 | 78
| 2 | NESTED LOOPS | | 4 | 312
|* 3 | HASH JOIN | | 40 | 2640
|* 4 | TABLE ACCESS BY INDEX ROWID | SHIP_LOCN_DTL | 40 | 1440
| 5 | BITMAP CONVERSION TO ROWIDS| | |
|* 6 | BITMAP INDEX SINGLE VALUE | C_SHIP_FUNC_PLD_IND01 | |
| 7 | VIEW | VW_NSO_1 | 2375 | 71250|* 8 | FILTER | | |
| 9 | HASH GROUP BY | | 119 | 111K
|* 10 | HASH JOIN | | 47493 | 2226K
|* 11 | INDEX FULL SCAN | C_SHIP_LOCN_DTL_IND3 | 47493 | 1669K
| 12 | INDEX FULL SCAN | C_SHIP_HDR_IND2 | 167K| 1964K
|* 13 | INDEX RANGE SCAN | C_SHIP_HDR_IND2 | 1 | 12