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
Post a Comment