index on ff tag tff *no optimization: calculate max(ff) *optimized calculate max(ff) for ff>0Help says, rushmore does optimize the FOR clause. Nothing said about calculate all in all. Perhaps it's intended to do a full scan, so the calculate result is always based on the data itself. As it's meant for financial and statistical calculations.