Home Forums SQL Server 2008 T-SQL (SS2K8) FULL text search RE: FULL text search
Ant-Green
SSC Guru
Points: 113445
More actions
December 12, 2012 at 4:12 am
#1567808
Thats the whole point.
%...% will cause a table scan no matter what indexes you have on it
FTS will do the seek and then a match on the FTI