Have Geek Brain

Can I use full-text indexing on a view?

I am using SQL Server 2000 and I am using full text indexing in a table. Can I use full text indexing to view this table? If so, how can I use? If not, what should I do?

Actually, I am doing a refinement of the results obtained from the table, and for this refinement I use the view of this table ...

+1


source to share


2 answers


No, you cannot use full-text indexing on a table view.

Apparently you can create it on an indexed view though .



See also: Creating an Indexed View

+2


source


I think you can create a full text index for the view. Here's the idea for creating a view.



fooobar.com/questions/727848 / ...

0


source






More articles:


All Articles