SQL Server Performance Forum – Threads Archive
Full text search – optimization & PagingGreetings, 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)
– Manufacturer What would be the best way to paginate and optimize such a query? TIA, AC.
… for a good start. HTH Satya SKJ
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