>>>>In my lame search, I have not been able determine if a FOX SQL statement with a GROUP BY clause can be optimized using indexes (rushmore). Is it possible?
>>>>
>>>>I have a large set of data created using the SET COVERAGE statement, and I am trying to aggregate the duration to find the lines that consume the maximum time. Currently the SQL statement is taking around 5+ minutes. I was thinking that if an indexes on the Method column would help in speeding up the aggregation.
>>>
>>>I read where Tamar had a series of computations that took about 30 minutes to complete. And here you say you have some code that takes around 5 minutes to complete.
>>
>>Not me, though I think I answered a question recently where someone had that.
>
>IIRC you were diagnosing a problem in a series of SQL statements that took about 30 minutes to complete and you weren't having the error until late in the process which made it hard to diagnose. I don't remember all the details of the post, but I do remember reading it took a long time to get there.

Pretty sure that wasn't me. I know how to diagnose that sort of thing and wouldn't like have been asking about it.

Tamar