In a stored procedure is there anything called as optimum number of rows that need to be handled in a batch
as In, If there is a SP,
that picks up data(via union operation) from various objects and puts them into a temp table after which the required data is moved to various tables,The above scenario is handled as a batch run where in 1 million rows are processed in a batch
and the next 1 million rows in a next batch,so on and so forth.
Is there any optimum number of rows that can be processed in the above case?
When we increase rows processed per batch we have seen improvements in performance of the SP,but not sure when it will start deteriorating.
View Complete Post