Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to speed up this SQL
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
How to speed up this SQL
Divers
Thread ID:
00940416
Message ID:
00940416
Vues:
77
This runs real slow. Any way to speed it up?
SELECT Id, EntryDate, TranDate, BatchId, EntityId, Count(*) AS Cnt;
  FROM Resh;
  WHERE Resh.Status == " " AND;
  BETWEEN(TranDate, dDateFrom, dDateTo);
  GROUP BY Resh.BatchId;
  ORDER BY &cSortOrder;
  INTO CURSOR Temp1
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform