When is it optimal to use a buffer-compare with the "using" fields option vs an "if" statement to compare each field? Is using the buffer-compare just easier to code, or are there other benefits at the engine level doing one vs the other?
buffer-compare will automatically expand to cover all applicable fields, while IF statement has to be manually updated.