MySQL Forums
Forum List  »  Full-Text Search

Explain this better
Posted by: Weydson Lima
Date: March 28, 2011 01:27PM

Warning: This is a newbie question. :) I've read the sticky post, but I couldn't find an answer for my question.

I'm dealing with some huge databases - over 60 million records with a lot of text searches such as first letter of the first name, partial text search, etc.. The fields are all VARCHARs.

So I've created 3 full text indices.
firstname
lastname
firstname+lastname

Is that the best approach?

Another question would be why would someone not want to use a fulltext index on a varchar field if queries are being executed against that field?

Options: ReplyQuote


Subject
Views
Written By
Posted
Explain this better
3511
March 28, 2011 01:27PM
1669
March 29, 2011 09:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.