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.
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
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