tags:

views:

119

answers:

2
Q: 

Can I use full text indexing on a view?

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...

+1  A: 

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

Mitch Wheat  2009-05-05 05:30:24
A: 

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

http://stackoverflow.com/questions/263071?sort=votes

jalpesh  2009-05-05 06:03:46

related questions

How do you know what a good index is?
What datatype should be used for storing phone numbers in SQL Server 2005?
What is the best way to build an index to get the fastest read response?
How would I go about creating a custom search index much like Lucene?
What is a Covered Index?
When should you use full-text indexing?
SQL/Oracle: when indexes on multiple columns can be used
Best use of indices on temporary tables in T-SQL
On Disk Substring index
How to implement a "related" degree measure algorithm?
Non-Clustered Index on a Clustered Index column improves performance?
HTML Help keyword location
One or Two Primary Keys in Many-to-Many Table?
Strategies for keeping a Lucene Index up to date with domain model changes
Do indexes work with "IN" clause
Table Scan vs. Add Index - which is quicker?
Why does SQL Server work faster when you index a table after filling it?
PostgreSQL: GIN or GiST indexes?
What's the difference between a Table Scan and a Clustered Index Scan?
Database Case Insensitive Index?
Testing for inequality in T-SQL
Tables with no Primary Key
How do I index a database field
How does database indexing work?
Why doesn't SQL Full Text Indexing return results for words containing #?