Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2000
Thanks Keith. If I understand you correctly, I create one view for each combinaison of joins possible and don't filter the data in the view. I will filter the data in the business layer. That's what you mean?
What is the difference between a stored procedure that return a table and a view?
>Don't use a single stored procedure with many different criteria possibilities. The performance can possibly be worse by a factor of 10 or more and you will have no control over it.
>
>If you have the storage space, consider creating an indexed view for each possible join structure and query it dynamically from the business layer. This will simplify the execution plans (SQL Server will spend less time analyzing the SQL before running it).
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