Full text search – optimization & Paging | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Full text search – optimization & Paging

Greetings, I would like to paginate my search query. Currently I am using SELECT TOP 1000 * from MySearchTable where
CONTAINS(KeywordText,'(FORMSOF(INFLECTIONAL,black) AND FORMSOF(INFLECTIONAL,paper)’)
ORDER BY Manufacturer Lets assume MySearchTable has only four fields. – ItemID (Primary Key)
– Description
– KeywordText
– Manufacturer What would be the best way to paginate and optimize such a query? TIA, AC.
http://www.sql-server-performance.com/tb_search_optimization.asp
http://www.sql-server-performance.com/full_text_search.asp
… for a good start. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks Satya, but I was looking more specific information. Thanks, AC
]]>