Is data manipulation faster when working with a List variable or a Table variable? For instance, I lets say I have a list of names and I want to compare it to a second list of names to see which ones match. Would it be faster to do these types of comparisons with Lists or Tables? My actual data will be closer to 100,000 rows, so I am concerned about performance.
Note: in theory, my data will only contain one column, thus it could (again, in theory) be stored in either a Table or List variable.