具有外连接的视图上的MS-SQL 2005全文索引 [英] MS-SQL 2005 full-text index on a view with outer joins

问题描述

我有一种观点，我想在其上应用全文索引。它当然需要一个唯一的聚集索引来允许全文索引。

不幸的是，我了解到您无法创建包含外连接的索引视图。问题是我的视图需要这些外部连接！

有没有办法让这种情况发生，或者我会被困在写一个复杂的存储过程？

解决方案

是否可以创建一个虚拟记录加入到此视图中？

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?

这篇关于具有外连接的视图上的MS-SQL 2005全文索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！