One more question,
One of the tables this query will be running on has referential integrity turned on and deleting from it is very slow. It has around 8mil rows and it takes longer to delete it than another table with 30mil. Will this slow it down any more?
As apposed to running this a bunch of times
where id_col in
where var = invar
fetch first 250000 rows only