Hi in general which approach should perform better when passed a collection of primary keys and performing a bulk sql operation, a forall loop or using an 'in' clause with table()?
For example if I had table x_tbl with a primary key x_id and I was passed a collection of x_id's as t_id and I wanted to delete all the rows represented by those primary keys which should perform better:
forall i in 1..t_id.count
delete x_tbl where x_id = t_id(i);
or
delete x_tbl
where x_id in (select * from table(t_id));
Thanks