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 |
|
prabhuch85
Starting Member
4 Posts |
 Posted - 2009-02-05 : 02:16:08
|
| I need to search on text which is in particular column in Db and get the rows and display the search result based on the text searched.For implementing with good performance, which type of indexing is accurate like clustered index,nonclustered index,full-text indexing et.cSolutions for above question are welcome !!!Thank you |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-05 : 08:53:49
|
| Full-Text Indexing. |
 |
|
|
prabhuch85
Starting Member
4 Posts |
Posted - 2009-02-06 : 00:22:09
|
| Is Full-Text Indexing is advisable when search is done from lakhs of records in DB |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-06 : 09:31:01
|
| Yes. |
|
|
|
prabhuch85
Starting Member
4 Posts |
Posted - 2009-02-07 : 00:10:06
|
| I need to search text on a particlular column which has a sentence (varcahr100) and not only one word. for example.. If a rows(R1) in the column has "Tutorials on Sql 2005 " as content . When "Tutorial" text is searched ,Row R1 has to be fetched and When "Sql 2005" text is searched ,Again Row R1 has to be fetched. So in that casewhich is the efficient index ( like clustered index,nonclustered index,full-text indexing etc..) to create on that column which has varchar as datatype in Sql..how abt creating a Non-clustered index with full text indexing Enabled?(on the particular column) is that best way ..And on what basis Fill Factor has to be mentioned..Thanks,prabhu |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-07 : 12:04:12
|
| http://technet.microsoft.com/en-us/library/cc917695.aspx |
|
|
|
|
|
|
sql indexing type for searching text