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...
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement