I'm trying to optimize a query used for generating a report. Right now it takes 8 seconds for it to return 58,850 records.

I removed some fields from the select to see if it would take less time. At first that had no effect on the time then I removed everything except the fields that are put of the indices. That caused it to only take 1 second. Obviously, I need more then just the key fields to generate the report but adding any field causes the time to jump up to 8 seconds.

Does anyone know why the time would increase like that or how to adjust the database the reduce the time to return the results. Well, aside from adding an index on all the fields.

Thanks,