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:09 am
#1567806
Well the full text is faster on time, yes it reads more pages from memory than the like, but doesnt do a scan which the like does, so full text wins on that one for me. Also Full text is less cost than the like so again, that shows it is better.