• 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