Thanks Sankar and Hugo for a good question. The performance and NULL handling are interesting and the wording really allowed only 1 realistic answer, knowing that UNIQUE constraint still allows multiple NULL entries. Option 2 might work, albeit slower, but violates existing business rules.