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: 913
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: Reports 9i/10g J2EE Thin Client for Websphere Application Server 5.x /6.x
Next Topic: REports 10g installation problem
Goto Forum:
  


Current Time: Tue Aug 22 02:31:47 CDT 2017

Total time taken to generate the page: 0.06418 seconds