Home » Developer & Programmer » Reports & Discoverer » CALCULATION DISCOVERER
CALCULATION DISCOVERER [message #256337] Fri, 03 August 2007 18:09 Go to next message
herramientas
Messages: 1
Registered: August 2007
Junior Member
i NEED YOU HELP ..PLEASE.

I HAVE A WORKBOOK WHIT CALCULATIONS , FOR EXAMPLE:


CUSTOMER TOTAL ITEM CALCULATOR
JHON HALL 1000.00 120.00
PHIL COLLEN 100.00 0.00
STEVE CLARK 399.00 100.00


THE CALCULATIONS ARE FAST, BUT ADDING A CONDITION THE WOORKBOOK IS SLOW.
THE CONDITION IS :
'WHERE ITEM CALCULATOR <> 0', THE QUESTION IS:

HOW CAN I IMPROVE THE PERFORMANCE REPORT?

Re: CALCULATION DISCOVERER [message #256720 is a reply to message #256337] Mon, 06 August 2007 07:58 Go to previous message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
NO NEED TO SHOUT, I'M NOT DEAF Wink
(are you aware of the fact that writing in capitals on a forum means that you're shouting?)

We will need more information on the tables, num rows, indexes involved. And preferably an explain plan for both versions (with and without the condition). Then we might be able to help.
Previous Topic: can we call oracle application express report from oracle forms 10g.
Next Topic: Dynamic image in report from path
Goto Forum:
  


Current Time: Wed Dec 07 11:03:56 CST 2016

Total time taken to generate the page: 0.05160 seconds