I have a view that I'd like to apply a full text index on. It of course needs a unique clustered index to allow for the full text index.
Unforunately, I learned that you cannot create an indexed view that contains outer joins. Problem is that my view needs these outer joins!
Is there a way to make this happen, or am I going to be stuck writing a complex stored procedure?
Is it possible to create a dummy record to join to for the purposes of this view?