Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL: where vs. join
Message
De
08/08/2009 13:22:19
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01416873
Message ID:
01416883
Vues:
71
>Are you sure about that? I thought you only got a Cartesian product if you coded the Where wrong.

Note that I was wondering, not about the end result (which I believe should be equivalent), but about intermediate results. These should normally not be visible for the end user, but if a query isn't optimized, it may be very, very slow, and in some cases, you might get temporary files above the limit. Which is what alerted me to this possibility in the first place.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform