full text index

Posted on 2011-04-24
Last Modified: 2012-05-11
First of all I would like to beg your perdon for my english.

My question is about full text index.

from the performance point of view, is it better one catalog per table or one catalog for all the tables?
what in your opinion should be the limits in terms of the number of fields per table than must be include in then index in order to keep the date base performance? (I have a table with 232 fields and around 72 varchar and text fields that can be included and I dont know if is a good idea to include all of them)
Question by:lespbaj
    LVL 42

    Accepted Solution

    by: depends on your environment:
    The sql server 2008 will store FTS catalogs in DB ndf files: so probably to keep  each FTS index in it's own ndf - is not so bad idea

    Best Practices for Integrated Full Text Search (iFTS) in SQL 2008

    SQL Server 2008 Full-Text Search: Internals and Enhancements
    LVL 21

    Expert Comment

    by:Alpesh Patel
    It based on your field access. The files which you use more ti get filter out data create index on that field.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now