Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>It's legal to use UNIONs in a view, as long as it's defined with CREATE SQL VIEW and you don't later attempt to modify it with the VFP View Designer.
>
>However...
>
>Is it good practice to use UNION clause(s) in a view? Or, is that usually a sign that the database should be refactored?
I think using UNION may be a (good) sign that the database is successuflly normalized. Usually views are used to denormalize data for particular uses, such as querying or reporting.
Précédent
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