|
I ran the query from both SQL Server Management Studio and Toad using bind variables rather than static and observed that the query took approximately 6-7 seconds to execute to return a total of 250 rows. This was using the composite key of itemId/plantId equating to 500 bind variables.
|