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 |
|
miktom
Starting Member
2 Posts |
 Posted - 2007-04-16 : 04:09:43
|
| I have a table with 13 colunms and 200.000 + rows. I need to be able to search for partial text inside these columns. How should I index this database for best performance? Tommy |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-16 : 04:14:28
|
| Full-Text Index would be my suggestion.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-04-16 : 04:15:04
|
| i think your best bet would be full text.you can put a clustered index on the pk and a nonclustered on every column and see what happens._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
bpgupta
Yak Posting Veteran
75 Posts |
Posted - 2007-04-16 : 05:52:30
|
| First you have to find out which columns is accessing having text and string data type ,which are going to be search .Now For fast accessing the Text and phare whithin the Text and String the best way to create Full Text on that column and start the MS Full Text Services on and you have to use certain fuctions in the query to serach the pharse in Text or string.It will be 10 times faster then normal indexing.BPG |
|
|
|
miktom
Starting Member
2 Posts |
Posted - 2007-04-16 : 06:07:50
|
| Thanks for all help. I've tried full-text indexing on the text columns, and it performed acceptable. :DTommy |
|
|
|
|
|
|
All-field index