Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rushmore optimized GROUP BY
Message
From
12/06/2019 11:29:21
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Rushmore optimized GROUP BY
Miscellaneous
Thread ID:
01669032
Message ID:
01669032
Views:
70
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.
Greg Reichert
Next
Reply
Map
View

Click here to load this message in the networking platform