I am using SQl server 2005 64 Bit Service Pack 2 with Full text on one table
and only on one field.
When I run query on my table of 800,000 rows Full text search find 4830
records within 18 seconds with skill Oracle in State CA.

SELECT * FROM srch.recent_people_search AS FT_TBL INNER JOIN
  CONTAINSTABLE(srch.recent_people_search, searchalltext, 'oracle') AS
KEY_TBL
  ON FT_TBL.recentpeoplesearchid = KEY_TBL.[KEY]
order by rank desc

To make it faster and make it more useful for my user I change the query to
show only frist 1000 records with  top ranking. When I do run the query below
It bring 342 records within 2 seconds eliminating other 700 rcords.

SELECT * FROM srch.recent_people_search AS FT_TBL INNER JOIN
  CONTAINSTABLE(srch.recent_people_search, searchalltext, 'administrative
and assistant',1000) AS KEY_TBL
  ON FT_TBL.recentpeoplesearchid = KEY_TBL.[KEY]
where statecode='ca'

The issue I am having is there are more than 1000 Oracle skill record in the
database in CA state but the way Fulltext use ranking it first select 1000
highest ranking record and then look for the next Where clause in this case
state of CA. Whcih basically defeat the purpose and come up with wrong data.

What can be done to take care of this isse.

Thanks in advance.

Thanks
Tanweer