How to further optimize non-clustered bit fields after implementing database tuning advisor recommendations in SQL Server 2008 R2?
===

With SQL Server 2008R2, given the following query:


	SELECT DISTINCT TOP (@NumberOfRecentSearches) LOWER(dbo.FilterRecentSearchesTitles(OriginalSearchTerm)) AS SearchTerms, COUNT(OriginalSearchTerm) --, COUNT(*) AS TheCount --, GeoID
	FROM UserSearches
	WHERE IsManualSearch = 1 
	AND LEN(dbo.FilterRecentSearchesTitles(OriginalSearchTerm)) > @MinCharLengthForRelatedResults
	AND WebsiteID = @WebsiteID
	AND UserAgent NOT LIKE '%google%'
	AND FREETEXT(OriginalSearchTerm, @SearchTerm)
	GROUP BY OriginalSearchTerm
	ORDER BY COUNT(OriginalSearchTerm) DESC


I created a trace file with SQL Server Profiler, then ran it through the DB Engine Tuning Advisor which made four recommendations to `CREATE STATISTICS` on the UserSearches table, which I did.  The result is after implementing these suggestions... and the tail of this execution path:

![Actual Execution Path][1]

I would like to know if this can be further optimized, seeing as the non-clustered index on a bit field is 91%.


Thanks.

  [1]: http://i.stack.imgur.com/1JsTB.png