I have a stored procedure to execute truncate statement, the statement is probably so, such execution down very slowly, advice on how to optimize the batch execution truncate;
I put truncate statement execution error together,

 create or replace sp_ant () 
The begin 
The execute immediate 'truncate table a'; 
The execute immediate 'truncate table b'; 
The execute immediate 'truncate table c; 
The execute immediate 'truncate table d'; 
The execute immediate 'truncate table e; 
The execute immediate 'truncate table f; 
The execute immediate 'truncate table g; 
The execute immediate 'truncate table h'; 
The execute immediate 'truncate table I'; 
The execute immediate 'truncate table j'; 
,,, 
End 

CodePudding user response:

down very slowly, so consult how to optimize the batch execution truncate;



Separate run, will soon?

CodePudding user response:

Effect is the same, but not more than a sqltruncate form

CodePudding user response:

Show that column to the cursor, but just good-looking, truncate should also not too slow, with separate execution, than time?