Home » RDBMS Server » Performance Tuning » advantage of append mode ??
advantage of append mode ?? [message #191068] Mon, 04 September 2006 05:59 Go to next message
Messages: 142
Registered: March 2006
Senior Member
insert /*+ append */ into customer values ('hello',';there');

insert into customer values ('hello',';there');

if both the above 2 statements are compared then the differences are :
1) the buffer cache ignore in append
2) data written from highwater mark

is there anything else ??

Re: advantage of append mode ?? [message #191083 is a reply to message #191068] Mon, 04 September 2006 07:38 Go to previous messageGo to next message
Messages: 52
Registered: August 2006
No redo log entries, which improves the insert performance.
Re: advantage of append mode ?? [message #191306 is a reply to message #191083] Tue, 05 September 2006 11:12 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
Using /*+ append */ doesn't avoid redo -- unless the table is NOLOGGING or you are not in archive log mode. The advantages of using the APPEND hint is as you mentioned, data is written above the HWM rather than searching for free space.
Previous Topic: analyze table
Next Topic: Hash join hint not being used
Goto Forum:

Current Time: Sat Oct 22 11:44:27 CDT 2016

Total time taken to generate the page: 0.10126 seconds