Mike Yearwood
Toronto, Ontario, Canada
Versions des environnements
>Would the execution plan not be cached if the parameter changed? Remember I'm being told the exact opposite. That the SP would be faster no matter what. I know complex SPs may be faster.
I definitely remember reading once that SP can be slower compared to unchanged dynamic queries. SInce I read a lot, it may be just coincidence and it might have been a false text anyway...
>
>Trust me. I know how to apply m. I'm doing it that way just for consistency. It's my style, if you could call it that.
I do - that is what makes me ask. So I cannot cite you for my "style" of mDotting only when reading / passing variables. On closer viewing: even mDotting a local statement! Style Police! Get Him! <bg>
regards
thomas
Précédent
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