Full-Text Index Search

Results 1 to 2 of 2

Thread: Full-Text Index Search

  1. #1
    Join Date
    Dec 1969

    Default Full-Text Index Search

    I have created a full-text index on a few tables in my database, and I am trying to find a search script that will generate highly accurate results, followed by close results, followed by results that are a bit of a stretch.<BR><BR>I understand the syntax of the full-text queries, and have read the articles on 4Guys and SQL Team, I really just wanted to know if there is a good example out there for doing this.<BR><BR>One of my main concerns is the performance. There will probably always be between 2k and 10k records that are being searched. I would appreciate any links or code ideas.<BR><BR>Thank you

  2. #2
    Join Date
    Dec 1969

    Default RE: Full-Text Index Search

    ONe suggestion could be to create indexes/stored procedures on tables since ur doing a database search to increase the performance.It makes a lot of diff. if data is huge.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts