Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement