Need a Hard Core MS SQL Guru to optimize a complex query which uses multiple tables and freetext searching:
Here is the situation:
our query searches many fields like first_name,email,last_name & so on
And query is searched for more than 1 keyword like "Alex America", so what we need : the records which match both "Alex" and "America" for any db fields should come first and then fields with only a keyword match i.e. either "Alex" or "America" should come after that.
The query is fully written and we just need to optimize it for proper sorting order.
Need someone fast to solve this within next few hours.