Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lebedev
Posting Yak Master
126 Posts |
 Posted - 2009-03-17 : 11:24:46
|
| According to this http://msdn.microsoft.com/en-us/library/ms187317.aspx full-text index can get out-of-date if the latest changes have not yet been indexed. Does it mean that queries relying on an index in an out-of-date state can return wrong results?From your experience how long does it take to propagate a change to a column with full-text index with AUTO option enabled? Are we talking about seconds or hours?Thanks.Alec |
|
|
lebedev
Posting Yak Master
126 Posts |
Posted - 2009-03-18 : 14:55:30
|
| I thought that would be a pretty straight-forward question by any SQL Server expert. Have I posted it in the wrong thread? |
 |
|
|
|
|
|
Full-text index correctness and administration