NormaLucia
New Member
In a case did you say that use temp table shared it's not a best practice, would you explain me more.
Why do you say that it's not the best practice?
Regards
Let me see if I understood well, I would try explain about my process, I have a procedure where I create a temp-table when finined it ,
return to principal program, my problem is that it's file it's so big that kill the broker for the time it take.
My principal file has about 50000 record, as you say me it's create a procedure and inside use temp-table would I use is ?. Can you explain me more.
Can I optimize the time process for not broke the time the broker. I had think in create table resume for optimize it., would you recomend another
I would be very happy.
Thanks
Why do you say that it's not the best practice?
Regards
Let me see if I understood well, I would try explain about my process, I have a procedure where I create a temp-table when finined it ,
return to principal program, my problem is that it's file it's so big that kill the broker for the time it take.
My principal file has about 50000 record, as you say me it's create a procedure and inside use temp-table would I use is ?. Can you explain me more.
Can I optimize the time process for not broke the time the broker. I had think in create table resume for optimize it., would you recomend another
I would be very happy.
Thanks