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: 267
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..



Report message to a moderator

Re: Tuning Report [message #556474 is a reply to message #555284] Mon, 04 June 2012 08:43 Go to previous message
arif_md2009
Messages: 678
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.

Report message to a moderator

Previous Topic: Reports Parameter Form Questions - Fields Missing
Next Topic: How to print Tick Sign in Reports 10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jun 19 21:33:16 CDT 2013

Total time taken to generate the page: 2.48694 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.