Oracle11g stored procedures used in the temporary table, the final result needs to be some data sum return
Small white would like to ask the great spirit, if the amount of data in the case of less than 10 w article,
Is summation of the original data and then inserted into a temporary table with high efficiency and insert the raw data into a temporary table first, then sum of high efficiency?

CodePudding user response:

Insert, do processing, 10 w data volume is not big

CodePudding user response:

reference 1/f, the breeze gently up response:

insert, for processing, 10 w

data is

bosses this is two kinds of processing efficiency gap is mean? That is the situation with what method can be handled?