Home » SQL & PL/SQL » SQL & PL/SQL » What is the functionality of NO_UNNEST hint?
icon8.gif  What is the functionality of NO_UNNEST hint? [message #248241] Thu, 28 June 2007 07:21 Go to next message
fastfreeeasy
Messages: 25
Registered: June 2007
Junior Member
What is the functionality of NO_UNNEST hint?
Where and under what situation this hint is more appropriate?
Re: What is the functionality of NO_UNNEST hint? [message #248243 is a reply to message #248241] Thu, 28 June 2007 07:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What does the documentation say?

Regards
Michel

[Updated on: Thu, 28 June 2007 07:27]

Report message to a moderator

Re: What is the functionality of NO_UNNEST hint? [message #248300 is a reply to message #248243] Thu, 28 June 2007 10:25 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
http://www.dba-oracle.com/oracle_news/2006_8_11_no_unnest_hint.htm
Re: What is the functionality of NO_UNNEST hint? [message #248306 is a reply to message #248300] Thu, 28 June 2007 10:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't trust what is in this site.
Use Oracle documentation.

Regards
Michel
Re: What is the functionality of NO_UNNEST hint? [message #248447 is a reply to message #248243] Fri, 29 June 2007 01:46 Go to previous messageGo to next message
fastfreeeasy
Messages: 25
Registered: June 2007
Junior Member
In Oracle book I saw that this hint executes a specific plan. In internet I searched about this hint, there I saw this hint gives performance benefit for tables having very high cardinality.
Re: What is the functionality of NO_UNNEST hint? [message #248449 is a reply to message #248447] Fri, 29 June 2007 01:51 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Links?

Regards
Michel
Previous Topic: Objects in Oracle
Next Topic: ROWID Storage in Oracle
Goto Forum:
  


Current Time: Fri Dec 09 00:15:29 CST 2016

Total time taken to generate the page: 0.09091 seconds