Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Full Text Index Population Expand / Collapse
Author
Message
Posted Thursday, April 24, 2008 11:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 17, 2013 2:02 PM
Points: 37, Visits: 114
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?


Post #490136
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse