Full text search with inner join very slow?

I would guess that the query plan shows that the three tables are joined together before the FullTextMatch is evaluated. If you execute the queries separately you force the plan to evaluate the FullTextMatch against Messages before the join. That might be good or bad for you depending on how much data is in the tables and how "selective" the where clause is against MailboxId.

If you see that you have a lot better performance with the queries separated you can use two table variable to store the intermediary result and query the variables for the joined output.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions