Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Creating views from normalized tables
i have a VFP .dbc that has normalized tables. some of the tables have as many as 30 FK's.
i am trying to create views from these tables and have run into limiltatins on how many joins i can have in a single select statement. through trial and error, i discovered that this limit is 8 joins.
so far, i have gotten around this by creating multiple views. and i know that i can join all of these smaller views into a single view to get the end result that i want.
i am curious to know if this approach is appropriate or if there is some other way to do this. i am concerned that this approach may lead to performance problems down the road when i have lots-o-data in the tables.
thanks, pbd
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement