Hello,

is it possible inside a stored procedure to dedactivate some index, do
the job, and reactivate the index at the end ?

it's because in the stored procedure we do a very massive insert, and
it's look like more efficient to deactivate the indexes, do the insert,
and them activate the indexes

i know that i can use execute statment ... but is it really safe to do so ?

thanks by advance