Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: performance issue in reports

Re: performance issue in reports

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Mon, 23 Jan 2006 17:36:34 +0100
Message-ID: <43D50612.1050802@skynet.be>


Haragha wrote:
> Hi kakatur,
> 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
>

In case kakatur doesn't answer: put the "earlier query" in the report, drop the "custome table", you'll gain the time lost with insert, update an delete. Received on Mon Jan 23 2006 - 10:36:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US