Home » Developer & Programmer » Reports & Discoverer » Tuning Report (Oracle database 10g, Report 6i)
Tuning Report [message #555284] Tue, 22 May 2012 22:58 Go to next message
swapnil_naik
Messages: 268
Registered: December 2009
Location: Mumbai
Senior Member

Hello Experts,

I want to your help...Currently i have task to tuning my existing reports...My Manager told me create procedure for that report and stored in backend...when report run just call that procedure...So it will take min. time compared to previous execution report time..

Is it really effective , if we make procedure on backened and call it on report...Is it take really less time...

Eager to know..



Re: Tuning Report [message #556474 is a reply to message #555284] Mon, 04 June 2012 08:43 Go to previous message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Dear Swapnil, i think your manager is suggesting to write procedures instead of formula columns to fine tune the report but it will not help that much , you need to check you main query first in sql or toad and check the cost.
Previous Topic: Reports Parameter Form Questions - Fields Missing
Next Topic: How to print Tick Sign in Reports 10g
Goto Forum:
  


Current Time: Thu Oct 02 10:32:10 CDT 2014

Total time taken to generate the page: 0.20909 seconds