The Metalink description of this hint seems
a little obscure. My experience is that it
simply allows you to reference a nested
table directly without 'pseudo-joining' it to
its rightful parent.
Given the funny games (such as using
a thoroughly spurious /*+ cardinality() */
hint, and bypassing the
Title: RE: /*+ NESTED_TABLE_GET_REFS +*/ hint
Thankyou Christian.
rgds
amar
http://amzone.netfirms.com
-Original Message-
From: Christian Trassens [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 2:11 PM
To: Multiple recipients of list ORACLE-L
Subject: Re
Hi,
I don't know if sby answered you, pls don't mind if
sby did it so.
It is a hint use it in exports, imports and loaders.
Here I enclose a note that maybe can clarify more
about it.
Problem Description
---
You are querying the sql area and keeps seeing
NESTED_TABLE_GET_REFS
In versions of 8i and below, the hint specifies that
nested tables should be retrieved as refs, and is
pretty much only seen on export.
In 9i, where you can collections of collections, then
its use by 'us' appears to be supported, but still not
documented.
Cheers
Connor
--- "Mohan, Ross" <[EMA
Title: /*+ NESTED_TABLE_GET_REFS +*/ hint
Oracle sys tab
accesses use RBO. I believe some have hints. check with the cognoscenti.
hth
-Original Message-From: Amar Kumar Padhi
[mailto:[EMAIL PROTECTED]]Sent: Friday, December 14, 2001 5:55
AMTo: Multiple recipients of list