Re: Select Distinct over Database Link

From: Herman de Boer <h.de.boer_at_itcg.nl>
Date: Tue, 20 Aug 2002 14:01:52 GMT
Message-ID: <ajti75$6ih$1@news1.xs4all.nl>

Gene Hubert wrote:

>I've tried the DRIVING_SITE hint but to no effect. It acts like all
>500 million records are going over the network to the database where I
>am logged on.
>

Hello Gene,

unfortunately, the driving_site hints seem to be ignored if used in a create-table-as-select, or an insert-select statement. There are some metalink / OTN hits, if one searches. Same behaviour even in 9.2.

Workaround is to create a view on the remote site.

Kind Regards,

Herman de Boer
sr consultant
IT Consultancy Group bv Received on Tue Aug 20 2002 - 09:01:52 CDT