when creating a full text index, how long should the initial population take? I created one Wednesday about 3:00 PM and it is still running. Now, stored procs that usually take about one second to run are taking a little over a minute. The table has about 33 million rows, has an id column (int) as PK, non-clusterd index on that column, and the full text index is on a varchar(28) column.
1. Should I let this process continue until it ends, or, should I stop the process?
2. Do I also need to add a timestamped column to the table for future populations?