July 17, 2008 at 7:40 am
we are having some peformance issue
To overcome this we are planning to enable full-texts search on tbl_notes, It is possible to enable full-text for a particular table.
how to do this and wil it effects performance.
Pls guide me on this.
July 17, 2008 at 11:04 am
Books Online has step-by-step directions on how to turn on full text indexing. I recommend following those directions.
It can affect performance, but Books Online also has data on how to manage that.
You'll need to make some decisions based on your specific situation and goals.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 17, 2008 at 1:13 pm
As per book online steps
we should go to db-> table->right clk and select full text index option,but here full text index option is not highlighted i,e we can't select that.so wat to do for that.
July 17, 2008 at 1:54 pm
ANJAN.ASHOK try reading this from BOL:
Getting Started with Full-Text Search
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/1fa628ba-0ee4-4d8f-b086-c4e52962ca4a.htm
It gives an example using the AdventureWorks database. It is reasonably detailed enough so to get you going.
You might also want to refer to:
Full-Text Search Concepts
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/db3747e0-db12-4c69-9d81-b5011984eb3a.htm
This page provides links to a whole host of full text search concepts on How-to topics
July 22, 2008 at 9:00 pm
I would be very surprised if Full text would help out with performance issues. Would need a little more info on what your actually trying to fix. The only time I can every get Full text to perform is replicating data to a dedicated box for the search functionality. Please give us some more details on the type of searches that our causing problems. I find there is a lot of confusion on actually what full text does in our community.
July 22, 2008 at 11:56 pm
Yes, it will help you...ashok
and its easy to implements also....
just go through the books online and do it..:)
Cheers!
Sandy..
--
July 24, 2008 at 11:08 pm
Again, how in the world is enabling full text search on a server that already has performance issues helping anything. I would argue there is a good chance running full text on this table will degrade overall performance of the server.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply