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 |
|
David92595
Starting Member
8 Posts |
 Posted - 2012-05-08 : 20:07:06
|
| Hello,Basics: I'm running SQL Server 2008 R2 back end with access 2007 front end.I have a Full Text Index set up on our main table which is have set up to re-index every morning at 3am, or at least that's what I'm reading in the Properties of the table. However, day after day our searches are still very slow. The table is relatively small only 14,000 records or so. So I know this should not be a big deal for SQL.Any suggestions for what I should be looking into to speed up searching of indexed fields?I am currently reorganizing the table on a nightly basis, a few hours before the re-index takes place. Could this have anything to do with it???Thank you in advance, and please let me know if you need more information.David92595 |
|
|
|
|
|
Full Text Index Not Working