>>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.
>
>So you have a cursor or table you created by importing SET COVERAGE data? I do that kind of thing as needed, and I've never had my queries against it be painful. I don't know for sure whether GROUP BY can be optimized, but can't hurt to try.
>
>Tamar
I have tried adding indexes for the GROUP BY / ORDER BY fields. But the Show Plan (SYS(3054)) indicates that no Rushmore optimizing is used.
Thanks for your thoughts.
Greg Reichert