| advantage of append mode ?? [message #191068] |
Mon, 04 September 2006 05:59  |
tridentadm
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 #191306 is a reply to message #191083] |
Tue, 05 September 2006 11:12  |
 |
ebrian
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
