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 |
|
piehawk
Starting Member
4 Posts |
 Posted - 2003-12-05 : 08:26:26
|
| Sorry if this is a bit simple, but am new to this area of SQL.Client has a website which is powered by a SQL2000 database on a shared platform.The site has a basic search facility which matches a couple of varchar fields.They now want to keyword search in a blob field and I've got an inkling that I should be indexing these fields. (Maybe I should have been indexing the varchar fields too!)Had a look around on the internet and there's a few different types, but am not sure which is the best. Also when I try to put an index on a blob field there doesn't seem to be an option for doing this.It has to be a blob field too as some of the data sizes are over the 8000 mark.Any help would be appreciated.To put it into context a little, it's a jobs website and they are currently searching on job title and location and they now want to be able to search through the job description too (blob field).Cheerspie |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-12-05 : 08:39:27
|
| I'm not the best one to answer this, but I think to search a BLOB field you need full text indexing.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
piehawk
Starting Member
4 Posts |
Posted - 2003-12-05 : 08:48:54
|
| Thanks Michael,I was a bit worried about that, as our shared server has that feature disabled.pie |
|
|
|
|
|
|
Basic indexing question