meaning of 'VW_NSO_1' [message #64678] |
Fri, 19 December 2003 20:05 |
Vinod Nair
Messages: 6 Registered: December 2003
|
Junior Member |
|
|
I have the following query explain plan
I don't know the meaning of 'VW_NSO_1'
in the plan
Execution Plan
-------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=3 Card=14 Bytes=224)
1 0 HASH JOIN (ANTI) (Cost=3 Card=14 Bytes=224)
2 1 INDEX (FULL SCAN) OF 'SYS_C005773' (UNIQUE) (Cost=1 Card
=15 Bytes=45)
3 1 VIEW OF 'VW_NSO_1' (Cost=1 Card=15Bytes=195)
4 3 SORT (GROUP BY) (Cost=1 Card=15 Bytes=45)
5 4 INDEX (FULL SCAN) OF 'SYS_C005773' (UNIQUE) (Cost=1
Card=15 Bytes=45)
Please explain me.
2. What are filters? In which case FILTERS are used?
Please explain with examples
|
|
|
|