--Version with 500 records
*********************************************************************************
UPDATE SALES_DATA SET STORE_MAX = :B4 , STORE_MIN = :B3 , FACINGS = :B2 , 
  FIXTURE_FILL = :B1 
WHERE
 ITEM_ID = :B6 AND LOCATION_ID = :B5 AND STORE_MAX IS NOT NULL AND STORE_MIN 
  IS NOT NULL AND FACINGS IS NOT NULL


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.00          0          0          0           0
Execute     56     72.87    1675.80     250355     521880      31720       31243
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       57     72.88    1675.81     250355     521880      31720       31243

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 28     (recursive depth: 1)

Rows     Row Source Operation
-------  ---------------------------------------------------
      0  UPDATE  
  31243   TABLE ACCESS BY INDEX ROWID SALES_DATA 
1166844    INDEX RANGE SCAN SALES_DATA_ORDER_PK (object id 7719611)

********************************************************************************

--Version with 1000 records
********************************************************************************

UPDATE SALES_DATA SET STORE_MAX = :B4 , STORE_MIN = :B3 , FACINGS = :B2 , 
  FIXTURE_FILL = :B1 
WHERE
 ITEM_ID = :B6 AND LOCATION_ID = :B5 AND STORE_MAX IS NOT NULL AND STORE_MIN 
  IS NOT NULL AND FACINGS IS NOT NULL


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.00          0          0          0           0
Execute    150    776.77   11287.71    1978190    7811035         42          38
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      151    776.78   11287.72    1978190    7811035         42          38

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50     (recursive depth: 1)