Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to speed up this SQL
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
How to speed up this SQL
Miscellaneous
Thread ID:
00940416
Message ID:
00940416
Views:
78
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
Next
Reply
Map
View

Click here to load this message in the networking platform