MS-SQL 2005 full-text index on a view with outer j

问题:

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?

回答1:

Is it possible to create a dummy record to join to for the purposes of this view?