SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

--+APPEND Hint -- advantages and disadvantages in OLTP system

Kevin_KOct 13 2005 — edited Oct 14 2005

I have a process in with an insert statement takes a lot of time. When I modify the insert statement to use --+ APPEND hint the insert time reduces a lot. There are a lot of indexes on this table and the table and indexes are in logging mode.

Can someone please clarify is using +APPEND hint will have any disadvantage in an OLTP system . Will any data be lost in case of failure?

Thanks a lot!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 11 2005

Added on Oct 13 2005

9 comments

3,755 views