Post reply

Full Text Index.

  • May 9, 2012 at 4:06 am

    #257681

    Hi,

    Is a Full Text Index stored on disk, and is there any way to find how much space they are using please?

    Thanks.

  • May 9, 2012 at 4:12 am

    #1484953

    yes they are stored like any other index, you can query the space in the GUI by clicking properties of the FTC under the storage node in SSMS and look at the catalog size

    you could run this aswell SELECT FULLTEXTCATALOGPROPERTY ('NameOfCatalog','IndexSize')

  • May 9, 2012 at 4:16 am

    #1484954

    Thanks, thats exactly what I needed.

    Do you know if FT Indexes are suitable for high transactin databases. Are there any limitations at all?

  • May 9, 2012 at 4:22 am

    #1484956

    the main thing to worry about is how often the table is updated as if you have set the FTC to be change tracking automatic then each update insert delete will cause the FT crawler to kick in to keep the FTC upto date. Search performance is dependent upon how large the base tables are and tha available resources at server level.

  • May 9, 2012 at 4:25 am

    #1484958

    Ok thanks.

    With the FTI being stored seperately from the base table; how does the FTI data link back to the base table?

    Let's assume I have a table with a Clustered Index on it.

    Thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply