2012年3月26日星期一

full text search on views?

Can we buld full text search on views? If yes, can I build a search catalog on a view that allowed both varchar and text columns?

Hi Abhi,

I've asked help for Tony Ting which is full text expert and here are his comments:

Answer is yes, but you could only build fulltext on indexed view (materialized view) and column are limited to all available in normal case but not on text/ntext/image/xml column. The later constraint is came from the current limitation that index could not be created on a indexed view w/ text/ntext/image/xml, but fulltext column need a primary index to work on.
Hope this helps.

Thanks,
Ana Elisa - MSFT

没有评论:

发表评论