If you ever, and I think many of use DBAs have, been in the
situation where you are stuck with data in the database that
isn't used and isn't accessed, data which may consist of rows
that are no longer used, data rows that aren't references,
because you don't use FOREIGN KEYs or they weren't applicable in
this case. Or data that was once used, but no longer is.
And in many cases, this data is tucked in among your other good rows of data :-( One way of cleaning up the database in a case like this is to run standard DELETE statements, but there are a few issues with this:
- You may be accessing a lot of data, so …