|
Hi Guys ,
I am using global temp table for a complex select .
This stored proc is called very frequently . Almost 200 calls per min . As
I have to clean up the temp table I included commit inside proc ( since temp
table is ' on commit delete rows ' ), but now my concern is .. will it cause
lots of checkpoints and degrade the performance fo db . If yes then what is
alternative ?
TIA,
bp
|
- Re: global temp table problem BigP
- Re: global temp table problem Jared . Still
