I only want to hire the programmer who ... knows what kind of join to use, and who does not have to “try them out first.”

Riddle me this: what's faster, bubble sort or quicksort?

Nota bene that I have not explained the characteristics of the data set.