Home » SQL & PL/SQL » SQL & PL/SQL » Using /* + Append */ insert hint
Using /* + Append */ insert hint [message #435486] Wed, 16 December 2009 07:46 Go to next message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member
Hi

is there any limitation for using the /* + Append */ insert hint? It say the /* + Append */ insert hint writes above the High Water Mark and the existing free space in block is not use.

I am not sure that is good to use it or not? Would you please help?

Thank you
Re: Using /* + Append */ insert hint [message #435490 is a reply to message #435486] Wed, 16 December 2009 07:57 Go to previous messageGo to next message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is a good use when you need it and not a good one if you don't need it.
See documentation for the usage of this hint.

Regards
Michel
Re: Using /* + Append */ insert hint [message #435581 is a reply to message #435486] Wed, 16 December 2009 23:33 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Append hint

regards,
Delna
Re: Using /* + Append */ insert hint [message #435908 is a reply to message #435486] Fri, 18 December 2009 15:58 Go to previous message
wakula
Messages: 150
Registered: February 2008
Location: Poland
Senior Member
Go to asktom - there was a discussion about adding APPEND hint to INSERT queries, its consequences and why it is not the default option in Oracle.
Previous Topic: Outer Join HELP
Next Topic: XML Parsing In Oracle
Goto Forum:
  


Current Time: Sun Sep 25 21:23:07 CDT 2016

Total time taken to generate the page: 0.11199 seconds