Full Text Index Rating

Question

Is there a way to estimate the size of a full-text index in SQL Server 2008? Obviously, this depends on the amount of indexed data. For example, if I have one column (like varchar (50)) in a full-text index, and I have 10,000 rows, what will be the size of the full-text index?

The reason I'm curious is because with a limited database size on shared web hosts, I want to make sure that the full-text index will not absorb all of my space.

I spent a lot of time searching for an answer and did not find it, so I really appreciate any help.

Answer 1

Create an index and see how big it is in relation to the underlying data.

If you really want to avoid creating an index, put a subset of your data in the test table and create an index for this:

select top 10 percent * into dbo.testtable from T order by newid() 

This request is expensive.