> So your recommendation is to just go ahead with the FK as it is?
>

My recommendation is the same as with any attempted optimisation: Work
on the bottlenecks, not just in theory-land.

I would declare the FK and do some real world benchmarks to see
whether this really does impact performance to the point where the
alternative (along with the limitations outlined in my prior answer)
becomes preferable.

Adam