Hi!
I'm using fulltext indexes and I can't understand what happens in the file
system.

This is my test:

1. I create the catalog:
CREATE FULLTEXT CATALOG FTC02_slave
ON FILEGROUP FG01_SLAVE
WITH ACCENT_SENSITIVITY=OFF

and SQL Server creates these folders:
\FTC02_slave
\FTC02_slave\MssearchCatalogDir

2. I create three fulltext indexes on three different tables (in the same
new catalog).
In \MssearchCatalogDir are created:
- one file .ci
- one file .dir
- one file .wid
- one file .wsb
with a total size of 54,9Mb

3. I drop the fulltext indexes:
in \MssearchCatalogDir there are no changes (total size = 54,9Mb).

4. I re-create the fulltext indexes (the same indexes, on the same tables,
on the same data). In \MssearchCatalogDir the file .ci has a double dimension
and the total size is 102Mb.

5. I execute: ALTER FULLTEXT CATALOG FTC02_slave REORGANIZE but there are no
changes.

6. I repeat step 3 and step 4 and now the total size di 152Mb.

7. Ad this point I drop e re-create the fulltext catalog and indexes and the
total size
in \MssearchCatalogDir is 54,9Mb.

Why the size doubles everytime I recreate the indexes? (the query
performance - with CONTAINS or COINTAINSTABLE- decreases everytime...)

I have to recreate the catalog everytime?

Please could some one help me?
Thank you in advance!

Paola