Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I optimize this query?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00803505
Message ID:
00803544
Views:
8
How long would take subquery if you run it separately? What level of optimization SYS(3054,11) shows?
SELECT MAX(ID) from payroll_tbl WHERE unemp_ins_pct > 0 INTO CURSOR tem
>Thanks Sergey. I tried your query, but it still seems to bring up the running query box on screen and seems to take same amount (status bar indicates 1 record in 5.41 seconds) of time as the query I designed. I have my indexes in table, and I thought it might be the ORDER BY clause that may be causing slow query, but apparently not.
>
>thank you
>Nick Patel
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform