Home » RDBMS Server » Performance Tuning » inserting data in append mode .. what adv ??
inserting data in append mode .. what adv ?? [message #191063] Mon, 04 September 2006 05:43 Go to next message
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: inserting data in append mode .. what adv ?? [message #191075 is a reply to message #191063] Mon, 04 September 2006 06:42 Go to previous messageGo to next message
wagnerch
Messages: 58
Registered: July 2006
Member
There is no difference between the two statements, according to Tom. See the link below:


http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:3224814814761#9877997417034


Here is the note in the Oracle Documentation:

Quote:

Notes:

Direct-path INSERT supports only the subquery syntax of the INSERT statement, not the VALUES clause. For more information on the subquery syntax of INSERT statements, see Oracle Database SQL Reference.

There are some additional restrictions for using direct-path INSERT. These are listed in the Oracle Database SQL Reference.




You can find this note in Chapter 15 of the Administrator's Guide under the title "Enabling Direct-Path INSERT".

[Updated on: Mon, 04 September 2006 06:46]

Report message to a moderator

Re: inserting data in append mode .. what adv ?? [message #191893 is a reply to message #191063] Fri, 08 September 2006 09:07 Go to previous message
goudelly
Messages: 52
Registered: August 2006
Location: India
Member

Hi,

Insert means simplly insert the values in to a table. means in your language it is append and it cant be overwrite the values.

for 'water mark'.. When you are inserting the values into table for ex: 10000 rows. your higest watermark will be 10000. Now you have deleted the 5000 rows and committed even though your water mark will be 10000 ok..


For removing the watermark for your table you can use the 'truncate' statement.

Thanks,

Mohan Reddy G Razz
Previous Topic: Index Usage and SQL Tuning Question
Next Topic: Big data Inserts
Goto Forum:
  


Current Time: Tue Dec 03 09:27:33 CST 2024