SQL Server Performance Forum – Threads Archive

search on text fields

1. Is full text search any good when anything can be searched on? 2. how is full text search best used.

I haven’t used it fully but so far it was giving better results for the search based queries, I would suggest to refer to the books online for more information. 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.

I am looking for real life experiences with this. I assume this is good when u know what words or pharases will be searched on…..thus create a catalog……create indexes on these words or pharases.

I’ve tested it, it works well, and is easy to set up, code for and maintain. Tom Pullen
DBA, Oxfam GB

do you allow searches on any text??

Any text column that’d been FTI’d. I must add that we just did this in testing, a custom written bolt-on to Peoplesoft. In the end the developers found it wasn’t needed as performance was ok without it. But our testing worked very well. Tom Pullen
DBA, Oxfam GB

just wondering if this is good when any words or phrased can be searched on. …have to test it out.

http://blogs.msdn.com/vinayakt/archive/2004/05/05/126329.aspx Blog &http://www.eggheadcafe.com/articles/20010422.asp for reference on setup. 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.

]]>