I am using SQL Server 2000 and I am using full text indexing on a table. Can I use full text indexing on a view of this table? If yes, then how can I use? If no, then what should I do?
Actually, I am doing refinement of the results obtained from a table and for this refinement I am using a view of this table...
From stackoverflow
-
No, you cannot use full test indexing on the view of a table.
You can apparently create one on an indexed view though.
See also: Creating an Indexed View
-
I think you can create full text index on view. Here is the idea for the creating a view.
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.