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

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

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

unit testing - How to mock PreferenceManager in Android? -