sql - When should you use full-text indexing? -


we have whole bunch of queries "search" clients, customers, etc. can search first name, email, etc. we're using statements in following manner:

select *  customer  fname '%somename%' 

does full-text indexing in scenario? we're using sql server 2005.

it depend upon dbms. believe systems not take advantage of full-text index unless use full-text functions. (e.g. match/against in mysql or freetext/contains in ms sql)

here article on when, why, , how use full-text indexing in sql server: understanding sql server full-text indexing


Comments

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

asp.net - In javascript how to find the height and width -

c# - DataTable to EnumerableRowCollection -