Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Commonly misused and abused VFP features
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00310951
Message ID:
00311173
Vues:
43
>>> since SQL works best on normalized data designs.
>
>Um, no. One of the reasons you denormalize is to make certain types of queries work better.
>

Andre,

Um, no, you denorlaize to make data retreival faster not to make it work better. You denormalize to eliminate the need for joins. SQL is designed for relational databases and if a database is not normalized then there is no guarantee that SQL SELECT will accurately get what you ask it for. Also,lease, let's not forget that SQL is more than SELECT, there's UPDATE, INSERT, DELETE, CREATE TABLE ...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform