I need to index my database, but I need to query it while it is indexing, it may take a long time, can I do that?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Your comments note that you're specifically talking about full-text indexing.
You can indeed query the database while a full-text index is being created. Full text indexes are created in the background on SQL Server 2005, 2008, and 2008R2.
You can continue to query the database using the LIKE operator, although of course the queries won't be as fast as a full text index, and your database server's performance may be degraded while the index is being created.