There are 20 tables in a database. Each one has a primary key but there is no referential integrity. More than 5 Million Rows per table with 10 percent being outdated. A strategy is needed to delete outdate records meeting the following requirements:
+ min execution time
+ min locking an application execution accessing data
+ min development effort
A.
use IF with single DELETE statement
B.
use single transaction with multiple DELETE statement
C.
use while loop with single DELETE statement
D.
use multiple TRUNCATE TABLE statements