anthony.green (12/12/2012)
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
ok so you mean here that we are good with the stats , full text gives us edge ok thanks , have you seen the exec plan too ( attached in my third last post .. capture.png) .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)