Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
Once created, that can be used again and again without doing compilation. That will save compilation time and get result in less time.
and the drawback
Stored procedure code is not as robust as app code, particularly in the area of looping (not to mention that iterative constructs, like cursors, are slow and processor intensive