Update Table Match Speed - which is faster: Matching multiple columns X, Y, Z (all integers) or Matching Col "X.Y.Z" unique combined string?
I'm Updating a large data table (4.4 million rows) of stacked data with design info from a much smaller table. I have 1,927 unique rows in the smaller table that correspond to the stacked parameter. They can be identified either by a column with a unique string (X.Y.Z), or the combination of three columns that contain X, Y and Z individually. The same columns (X, Y, Z and X.Y.Z) are in the larg...