I have not used this sp. We have a dynamic SQL statement generated by a sp.
For performance reasons I would like to use it to reduce the number of
explain plans created. I would like to understand its usage and pitfalls
(if any) to its use. Any comments from the user community?