General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only