Re: Simple Oracle Query Taking Too Long

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 07 Sep 2006 07:04:03 +0200
Message-ID: <8u9vf2hcvgabff9oeeo7ukqdd7ivepa1c6@4ax.com>

On Wed, 6 Sep 2006 15:01:06 -0700, "Bryan Hunter" <bryan_at_exitexchange.com> wrote:

>The table in question is only being accessed by the procedure that is moving
>the data from that table to the other one. So there are no inserts or
>updates being performed on this table. So I assume since that since there
>is no data manipulation occuring that the data stays intact and that the
>select and delete get the same data.
>

Your assumption is false. The data *can* be accessed. You should *never* rely on assumptions like this, or you must be willing to become an expert in crap applications and have other developers and administrators suffer because of your applications.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Sep 07 2006 - 00:04:03 CDT