Re: Select Distinct over Database Link

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Tue, 20 Aug 2002 19:45:19 +0400
Message-ID: <ajto6m$bm1$1@babylon.agtel.net>

<Kenneth Koenraadt> wrote in message news:3d625712.3713780_at_news.capgemini.se...

> Those "intermediate" commits, as you call them, are just good practice
> when inserting > 1M records. Nothing to do with the problem itself.

Why are they good practice for >1M rows? Which resources will they save/release? Which problems they will help to avoid when issued in a loop over a cursor? Does your statement mean that they are not a good practice for <1M rows? Please clarify.

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.

Received on Tue Aug 20 2002 - 10:45:19 CDT