Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Versions des environnements
SQL Server:
SQL Server 2000
>>This monstrous query is very hard to read and impossible to understand. Can you break it to managable pieces using either CTE or temp tables?
>
>Hi Naomi - as I said my TSql is very limited - don't know what CTE is and how would temp tables help ? - thanks
Hi Pete
if I was attempting to improve the performance of the query I'd first remove all the sub queries in it. See how the basic query performs and how it can be improved . then run the sub queries on their own and do the same for them then put it all back together.
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