MS SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesMS SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old July 13th, 2004, 02:30 PM
eph eph is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2004
Posts: 1 eph User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Full-Text Indexing

I have a table of product inventory I want to be able to search using the CONTAINS and/or FREETEXT functions. There are actually 4 columns I want to be searchable: brand, product name, etc. Since the table can have only one full-text index, should I just define an index on all 4 columns? It would be large in relation to the table, but the table itself is small (~600 rows). The index would not exceed the 900 byte limit.

Will this give me problems in terms of workability or performance? Is there a better approach? I could also just use LIKE searching, but it's significantly less sophisticated.

Thanks in advance.

Reply With Quote
  #2  
Old July 18th, 2004, 04:48 AM
Salizar's Avatar
Salizar Salizar is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2001
Posts: 289 Salizar User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
That depends.
I would suggest using full-text searches on columns that are text or ntext only. Using full text search for a brand name seems like a waste when you could easly use LIKE instead for those columns.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesMS SQL Development > Full-Text Indexing


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway