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
 

Reply via email to