>In some cases, I do a pre-digest which summarizes as you suggest. In other cases I do not. I was just curious if you had experienced the same results. Try creating an index and doing a group by with and without the index to see the performance. Also the number of records can make a difference.
I am sure the index can both help, and interfere if there is more than one expression. The main difference is that potentially, the number of records processed is much greater with summary calculations.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
