Inventory Item Import Performance Degradation

The INV Item Import Performance report is specifically designed to be an analytical report to predict the performance of inventory item load background processes.

If the number of items processed per second decreases as the total items processed increases, the report indicates that the interface SQLs are most likely using a wrong nonselective index, and corrective action should be taken to fix the SQL.

Once identified, the SQL should be analyzed and corrected, usually by reviewing the execution plan (using reports like DBA SGA SQL Execution Plan History) and ensuring indexes are appropriately used to avoid nonselective reads.