472,103 Members | 1,083 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,103 software developers and data experts.

Table with searchable string fields


I have a table, which is loaded once and never updated. One of its
columns is string (titles up to 100 chars). The content of this column
will be searched as the whole value (select * from books where title =
'Effective C++';) or as a single word (select * from books where title
like '%C++%';). The table contains millions raws.

What is the effective design?
Is creating index for my string column is sufficient?
Do I need index for all 100 chars, if most of the time I have no more
than 30-40 chars?
Maybe I need FULLTEXT index?

Thanks a lot for your help!


Aug 11 '06 #1
0 1855

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jay | last post: by
reply views Thread by John Pether (john | last post: by
1 post views Thread by chelleybabyger | last post: by
39 posts views Thread by Zak McGregor | last post: by
3 posts views Thread by DanPerlman | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.