hi have a table with 2.5 million records which i try do delete. i have several constraints on it too.
i tried to delete the records using delete but it does not seem to work. the delete runs forever. hrs...
i cannot truncate it as it complains about foreign keys.
What is the problem ?
Thanks Alex
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
