Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed.gamma.ru!Gamma.RU!news.tele.dk!news.tele.dk!small.news.tele.dk!uio.no!newsfeed1.uni2.dk!dfeeder1.cybercity.dk!dspool1.cybercity.dk!dreader2.cybercity.dk!not-for-mail
From: "Acme Acmeson" <nahdsl232734@nahvip.cybercity.dk>
Newsgroups: comp.databases.oracle.server
References: <1154781076.756804.66750@s13g2000cwa.googlegroups.com>   <ul99d2hfcv5sqadk03k4rildj2sdqonfot@4ax.com> <1155051487.594964.185240@n13g2000cwa.googlegroups.com> <44d8b363$0$6989$9b4e6d93@newsspool1.arcor-online.net> <1155053840.563027@bubbleator.drizzle.com>
Subject: Re: Fast utility to transfer data from one database to another excluding IMP/EXP
Date: Tue, 8 Aug 2006 20:15:47 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
Lines: 40
Message-ID: <44d8d4ca$0$67262$157c6196@dreader2.cybercity.dk>
NNTP-Posting-Host: 85.81.112.71
X-Trace: 1155060938 dreader2.cybercity.dk 67262 85.81.112.71:29034
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:272388


"DA Morgan" <damorgan@psoug.org> wrote in message 
news:1155053840.563027@bubbleator.drizzle.com...
> Maxim Demenko wrote:
>> superG schrieb:
>>> If you use CTAS, I suggest to use the following hint in SELECT:
>>>
>>> /*+ append parallel( <table_name>, <parallelism degree>) */
>>>
>>> Bye
>>>
>>> G. Pignatelli
>>> Sybrand Bakker wrote:
>>
>>>> -- 
>>>> Sybrand Bakker, Senior Oracle DBA
>>>
>>
>> And what is the append hint in the select good for ?
>>
>> Best regards
>>
>> Maxim
>
> Performance.
> -- 
> Daniel A. Morgan
> University of Washington
> damorgan@x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

When inserting rows the append hint may have an impact, but also when 
selecting ?
Didn't know that. Are you sure ?
Regards
Keld Nielsen