SQL Server Full Text Search Optimization
Full text indexing is a great feature
that solves a long running database problem, the searching of textual data columns for specific words and
phrases in SQL Server databases.
Full text indexing is a great feature
that solves a long running database problem, the searching of textual data columns for specific words and
phrases in SQL Server databases.
However, as the full-text search engine is a
separate component of SQL Server (it uses the Microsoft Search Service) this
can be a potential performance problem due to the way full-text search interacts
with SQL Server.
Full-text search works really well when you are
searching a text column and you are interested in all the rows that match your
highly selective search criteria. However, full-text search is commonly used
with other SQL Server predicates, such as those included in the WHERE clause.
powered by performancing firefox
No comments:
Post a Comment