Home » RDBMS Server » Performance Tuning » meaning of 'VW_NSO_1'
meaning of 'VW_NSO_1' [message #64678] Fri, 19 December 2003 20:05 Go to next message
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
Re: meaning of 'VW_NSO_1' [message #64683 is a reply to message #64678] Mon, 22 December 2003 22:39 Go to previous message
Frank Naude
Messages: 4578
Registered: April 1998
Senior Member

VW_NSO_1 should be the name of a view on your database. To verify:


Best regards.

Previous Topic: buffer cache holds objects not listed in dba_objects
Next Topic: statistics
Goto Forum:

Current Time: Thu Feb 22 02:19:16 CST 2024