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 |
|
ballabhoks
Starting Member
18 Posts |
 Posted - 2003-10-23 : 03:41:11
|
| I am managing a database contains 6 tables, but size of all 6 tables is very huge (all 6 tables contains more than 10,000,000 records). I am making Full text index on these tables but it is taking very much time druing creation of Full text index. Can anyone help me that Full text index creation time gets reduced. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-10-23 : 08:03:24
|
| how much 'very much time'?you've given us a start...6 tables, 10m records....but what spec machine (client/server)/ sql server version?...and what else is it being used for?at the moment...it's a "how long is a string" type problem. |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2003-10-23 : 14:32:43
|
| Are you trying to dump all the columns from your large table into the index? That's going to take much longer if you are. Try to limit it only to columns that are useful to the search. For example, here we have an account master table. We wanted reps to search by contact name and then pull back related info(city, state, zip etc). We created a full text on the customer number and the contact, not all the other columns. Once we find our record then we join back to the larger table. It took the query from 18 down to 4 seconds. Just an assumption as to what you're doing on my part.Mike"oh, that monkey is going to pay" |
|
|
|
|
|
|
FULL TEXT INDEX