Can you make a query run faster?

  • Thread starter Thread starter crazedadmin
  • Start date Start date
C

crazedadmin

I designed a report to run off of a query that contains quite a fe
calculated fields based on a date range

When I try to run the report for older data - lets say 8/1/04 t
8/31/04, it runs forever, and I have yet to actually see the repor
come up

When I run the same report for newer data - 3/1/05 to 3/31/05 - i
takes a minute or two, but report comes up fine

Is there anyway to get the query to run quicker? Or is it becaus
there are so many calculations being done

Please help!!
(e-mail address removed)
 
Hard to exhaust it based on the info provided, but it looks like placing
an index on the date field in the table would be a good start.
Also, do the same on any other field you are filtering on.

As for calculated fields, it depends on the calculation. If you are
using domain aggregate functions, for instance, you should expect them
to slow down the query; if you are just carrying out sipmle calculations
(like adding, subtracting, multiplying, dividing) between feilds in the
same record, the impact should be minimal.

There may be other things, but one would have to have the picture of the
query design to say more.

HTH,
Nikos
 
Back
Top