Two issues can significantly improve query performance:
Limiting the number of rows returned by the Enhanced Full-Text Search engine
Ensuring the correct join order for queries
View this book as PDF
