OraFAQ Forum: Performance Tuning » inserting data in append mode .. what adv ??

Home » RDBMS Server » Performance Tuning » inserting data in append mode .. what adv ??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

inserting data in append mode .. what adv ?? [message #191063]

Mon, 04 September 2006 05:43

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 ??

Report message to a moderator

Re: inserting data in append mode .. what adv ?? [message #191075 is a reply to message #191063]

Mon, 04 September 2006 06:42

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

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

Report message to a moderator

Previous Topic:	Index Usage and SQL Tuning Question
Next Topic:	Big data Inserts

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 13:47:50 CST 2024