October 26, 2004 at 7:24 am
i want to know when a grouped procedures are recopiled, supposed i have
create proc v;1 as...
create proc v;2 as...
and i use
exec v;1
exec v;2
exec v;1
is there any recompilation?
October 26, 2004 at 9:50 am
Each is only compiled the first time, or when it's not in cache. These aren't grouped in any way other than similr naming as far as I know.
October 27, 2004 at 12:53 am
10x steve, u know i can't find a good documentation about this fact.
i understand that i can use this kind of procedure for precompile the alternatives of a procedure. am i right?
this means if i have a ugly proc with if ..else, i can make more proc in a group and then i can use another proc where i have the conditional and i just call the other procedure, which can be already compile.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply