Impliment Full Text Indexing on a big DB

[mayhemIam]

Hi folks. I've been trying to implement FTI on our big DB. The table in question is 16 GB and query performance is horrible, thus the reason to implement FTI on the DB.

I don't want to create a new FTI enabled table and move the old data to the new table, I want to point the current table to my partition scheme, and as I understand correctly this can be done by dropping your Primary key and recreating it and pointing it to your partition scheme.

My Unique Index is IxNo on the table MF_Main, my Partition key is IxNo, the columns participating in the Full Text queries are FromAcc (varchar 2000) and ToIxAcc (varchar 2000). The

1. Enable FTI on your DB
2. Create FileGroups and physical location of FileGroups.
3. Create partition Function (DateTime - SwiftDatetime)
4. Create partition Scheme

The problem I have stems from dropping the Unique Index PK_MF_Main (Unique, Non-Clustered) on the table and recreating it on the Scheme defined (EFS_PartSche).

I get the following error

"Column 'Swiftdatetime' is partitioning column of the index 'PK_MF_Main'. Partition columns for a unique index must be a subset of the index key."

Please help me, I don't know what I'm doing wrong here.