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: 4565
Registered: April 1998
Senior Member
Hi,

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

SQL> SELECT * FROM DBA_VIEWS WHERE VIEW_NAME = 'VW_NSO_1';

Best regards.

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


Current Time: Thu Sep 24 16:10:32 CDT 2020