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 |
|
aditya2010
Starting Member
10 Posts |
 Posted - 2010-04-19 : 21:46:57
|
| Hi,We had a table presently around 12000 rows.It has got upto 10 indexes.It also had a fulltext index on a Title column.It used to work normally.We had a small relase in database yesterday.Suddenly,i observed, that full text search drastically slowed down.In the relase,we haven't altered any thing for that table.After struggling sometime,we tried to remove 2 indexes,and saw it was again faster.Now my question is,With those indexes prior,fulltext search is working fine.Can anybody guess what could be wrong?Also i had a question,i know more indexes consume more table space.So,removing 2 indexes may free some space and that helped fulltext search faster?or could be anything else.Please help me in ressolving this problem. |
|
|
|
|
|
Very slow Fulltext search sql server 2005