The invention discloses a united unique index traversal method and device, equipment and a storage medium, and the method comprises the steps: firstly obtaining all field distinction degrees of a
database data table, then traversing corresponding fields of a preset data table data range according to the field distinction degrees, determining a field
lower limit condition of next traversal, and obtaining a united unique index corresponding to the field
lower limit condition; and finally, corresponding fields in the data range of the preset data table are traversed in sequence until a field
lower limit condition of next traversal is not formed any more, and the problems that in the
database comparison process at present, united unique index traversal is carried out, multiple fields exist, and each field has an ascending order, a descending order and other possible scenes are solved, so that when data are traversed in batches, the efficiency is high, and the efficiency is high are solved. The technical problem that united unique index traversal is inaccurate due to the fact that the upper limit and the lower limit of each batch of acquisition records may not complete a
result set closed loop of a first field (or multiple fields) due to different UK field recognition degrees is solved.