Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select with GROUP BY - much slower than without
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01110065
Message ID:
01110233
Vues:
16
This message has been marked as a message which has helped to the initial question of the thread.
<snip>

>>3. A matter of style - I'd find it easier to read if you were to use local aliases in your SELECTs.
>
>Do you mean I need to use aliases for my tables, such as Trans tr, Trans_Employees_Queues teg, etc.? Do you think it would improve readability?

As long as you use meaningfull aliases, the readability will improve. Compare
Trans_Employees_Queues.Some_Field = Employee_queue_schedules.Some_Other_Field
* and
teq.Some_Field = eqs.Some_Other_Field
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform