Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I optimize this query?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00803505
Message ID:
00803544
Vues:
9
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform