Are there any standard ways to optimize full text searches.
Are there any dbcc or any other commands to do so.

Thanks,
Alok.

Alok,
If only it was as simple as a dbcc... <sigh>
Unfortunately, there is no simple way, and depending upon your SQL Server
version (select @@version), and what you want to optimize (FT Indexing &/or
FT Searching), I'd recommend that you review SQL Server 2000 BOL title
"Full-text Search Recommendations"

Regards,
John



[quoted text, click to view]

the best way to optimize the performance of SQL FTS is to limit the number
of rows returned by MSSearch. With the ContainsTable and FreeTextTable
predicates there is a top parameter you can use for this. You have to be
careful using this top operator to return all rows that match other
restrictions you are doing in your query.

Other strategies revolve around caching results sets for frequently searched
on items, so they are returned from cache and not from repeated hits on your
catalogs.

--
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html


[quoted text, click to view]