Grant Fritchey
SSC Guru
Points: 398890
More actions
May 30, 2008 at 5:59 am
#822239
Since you're already joining to the table, why not use the FREETEXT in the WHERE clause instead of joining the table to itself?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"- Theodore Roosevelt
Author of:SQL Server Execution PlansSQL Server Query Performance Tuning
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply