Re: Performance issue

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 09 Dec 2005 22:48:23 +0100
Message-ID: <3sujp1h4mf88mtaftc8hp77llvf5m09hcn@4ax.com>

On 9 Dec 2005 10:51:18 -0800, "Haragha" <harsha7890_at_gmail.com> wrote:

>Hi
> i have report in report 6i, i made the modification by
>creating a custome table and dumping data into it from earlier query by
>inserting and updating data from formula coloumns. Then I am selecting
>the data from the table and sorting it by a coloumn and deleteing the
>data after report.
>
>The problem is its taking more time to run the report, so what do u
>think the reason might be.
>
>Harsha

The reason is you are wasting resources by setting up a redundant temporary table.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Dec 09 2005 - 15:48:23 CST