0

I have SQL Server 2000 SP4 running on Windows Server 2008, and I'm trying create a full text catalog that includes full text indexes on a few tables. The catalog has an Item Count of 53676, but a unique key count of only 8.

On another database (a Windows Server 2003 machine) with the exact same data, i have the exact same Full Text catalog set up and the unique key count is 75312.

What could cause the unique key count to be so low?

abatishchev
  • 98,240
  • 88
  • 296
  • 433
Yisroel
  • 8,164
  • 4
  • 26
  • 26

1 Answers1

0

Have you checked the minimum and maximum indexed word lengths are the same on both machines?

moonpatrol
  • 1,202
  • 11
  • 15