RE: newbie: problem in dynamic SQL

2001-02-01 Thread paquette stephane
Hi, One of the reason I'm saying that is that I just tuned a batch job where in a huge loop there was a create and a drop table . Performance was awful. I'm more a development dba than a production dba so I'm usually aware of all objects in the database. The main thing is that "usually" the

RE: newbie: problem in dynamic SQL

2001-01-31 Thread Gabriel Galanternik
stephane, just curious, really, no subtle lines... should I, a developer, tell my dba that I'm gonna create temporary tables? (I know most of you are dba's, please don't flame me...) deep inside I would say, yes, but, really why? Rigth access? space allocation? performance tunning? curious dba?