I have a situation where I need to delete records
based on any one of 100 foreign keys. A total of
about 400,000 records need to be purged.
What is the best way to achieve this goal. I could
do a DELETE FOR INLIST(fk, 2,5,7,8,9,...xxx) but inlist
is limited to 24 expressions.
Perhaps a DELETE FROM tablex WHERE fk IN (sub query)
is the best...
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only